Welcome to the SQLitening support forums!
Started by Marc Giao, October 18, 2011, 05:17:46 PM
Quote>> Likely you are hitting a problem causing SQLite to create an automatic> index for this type of query. Fixed here:>> http://www.sqlite.org/src/ci/**27c65d4d9c?sbs=0<http://www.sqlite.org/src/ci/27c65d4d9c?sbs=0>>> Updating to 3.7.8 should fix it.>>That's it!, I've setPRAGMA automatic_index = false;and it's back to normal speed.Seems a very long hold up just for creating an index though - It's a verysmall table really, < 100 rows.Anyway happy enough with a workaround for now, appreciate your help.Cheers,Owen.
slEXE( "PRAGMA automatic_index = false", "E" )