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 <mwie...@ahsoftware.net> 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 > 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 > _______________________________________________ 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