On 17 October 2011 17:51, Dan Kennedy <danielk1...@gmail.com> wrote: > > 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 set PRAGMA 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 very small table really, < 100 rows. Anyway happy enough with a workaround for now, appreciate your help. Cheers, Owen. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users