LiveCode and SQLite performace
pete at lcsql.com
Thu Jul 23 19:47:24 CEST 2015
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 <mwieder at 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,
> > 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
> ahsoftware at gmail.com
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode