> On Mar 3, 2017, at 2:52 PM, Josh Hunsaker <josh+sql...@nispio.net> wrote: > > Your problem might be mitigated if you could compile your queries in advance.
Precompiled statements are a must if you want the best performance (and you’re running the same queries over and over.) Andrew, how many database handles are open? —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users