LiveCode and SQLite performace

Mark Wieder mwieder at ahsoftware.net
Thu Jul 23 01:58:25 CEST 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.

-- 
  Mark Wieder
  ahsoftware at gmail.com



More information about the use-livecode mailing list