Ward, Thanks for this.
We are already doing ANALYZE and sadly its not made any difference,. Rob > On 3 Jul 2015, at 00:04, Ward Willats <sqlite-users at wardco.com> wrote: > > >> On Jul 2, 2015, at 3:16 PM, Rob Willett <rob.sqlite at robertwillett.com> >> wrote: >> >> We?re trying to understand whether or not we have a performance problem with >> our Sqlite database. > > It may or may not apply to your situation, but after doing lots of inserts, > running ANALYZE can sometimes work wonders. > > -- Ward > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users