LiveCode and SQLite performace

Peter Haworth pete at lcsql.com
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 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
>   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:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


More information about the use-livecode mailing list