On Wed, Dec 5, 2012 at 10:28 AM, Keith Chew <keith.c...@gmail.com> wrote: > > I wonder what could be causing sqlite to hang so long? Will try to > remove all indexes to see if that narrows things down.
It is not an indexing issue. For one of the UPDATE SQLs, it is updating a table with only 1 record in it. And this takes > 350ms... All the other tables have only 1 or 2 indexes, so should not be impacting the inserts/updates. Regards Keith _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
