LiveCode and SQLite performace
mwieder at ahsoftware.net
Wed Jul 22 19:58:25 EDT 2015
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.
ahsoftware at gmail.com
More information about the Use-livecode