On 25 May 2014, at 11:22pm, Andrew Arnott <andrewarn...@gmail.com> wrote:
> It isn't clear why the slow one would be so much slower. Compare the two query plans using EXPLAIN QUERY PLAN SELECT ... with each one: <http://www.sqlite.org/lang_explain.html> > Is there > an opportunity here to optimize SQLite for the slow query form? First, do ANALYZE, then try EXPLAIN QUERY PLAN again in case the plan changed. Then create some appropriate indexes and see whether SQLite decides to use one. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users