LiveCode and SQLite performace

Peter Haworth pete at
Thu Jul 23 19:47:24 CEST 2015

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 <mwieder at> 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
>   ahsoftware at
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:

More information about the use-livecode mailing list