Hi Mark, I couldn't say for sure but I'm 99% sure the indexes are not recreated each time the database is opened.
On Wed, Jul 22, 2015 at 4:58 PM Mark Wieder <[email protected]> wrote: > 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 > [email protected] > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
