Isn't this the result of the results cache? The two queries are identical.
On Mon, Nov 10, 2014 at 9:26 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > RP McMurphy wrote: > > Is there a way we can make the w index work with both queries and not > > have to run external loops to flatten all the WHERE clauses? > > <http://www.sqlite.org/lang_analyze.html> > > sqlite> .timer on > sqlite> select count(*) from v where z = 0 and > ...> ( y between 1000000 and 1001000 > ...> or y between 2000000 and 2001000 > ...> or y between 3000000 and 3001000 > ...> or y between 4000000 and 4001000); > 1334 > Run Time: real 1.100 user 1.092007 sys 0.000000 > sqlite> analyze; > sqlite> select count(*) from v where z = 0 and > ...> ( y between 1000000 and 1001000 > ...> or y between 2000000 and 2001000 > ...> or y between 3000000 and 3001000 > ...> or y between 4000000 and 4001000); > 1334 > Run Time: real 0.002 user 0.000000 sys 0.000000 > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
