Have recompiled and indeed this makes both statements run at the same fast speed. I can also see that the both Explain now produce near enough the same. So it looks this has fixed it. I can see now that this could affect query speed not only in unrealistic testing situations, so this looks a useful fix.
RBS On Wed, Jan 4, 2017 at 1:09 AM, Richard Hipp <d...@sqlite.org> wrote: > On 1/3/17, Richard Hipp <d...@sqlite.org> wrote: > > On 1/3/17, Richard Hipp <d...@sqlite.org> wrote: > >> On 1/3/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > >>> > >>> Firstly, is this a bug? > >> > >> No. A "bug" means it gets the wrong answer. In this case, it gets > >> the correct answer, just more slowly than you would like. That means > >> this is an optimization opportunity. > >> > >> Thanks for bringing it to my attention. > > > > Please experiment with this version of SQLite: > > https://www.sqlite.org/src/info/acdb8f6f10953ed4 > > Wrong version. Sorry. Should have been > https://www.sqlite.org/src/info/62e9270a8057d758 > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
