LiveCode and SQLite performace

[Mark Wieder]

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