On 07/22/2015 02:11 PM, Peter Haworth wrote:
You'll see auto indexes for any columns that are defined as UNIQUE, that's
how sqlite enforces that constraint.
Doh! You're right.
I could swear the documentation said you had to compile sqlite with a
non-default compiler option to get this to happen, but the reality is
that you have to do that to *prevent* it from happening. So do you know
if the indices are stored with the database or are they just recreated
at each load? That might explain the long wait times on open.
--
Mark Wieder
ahsoftw...@gmail.com
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
