I like this feature :) https://sqlite.org/pragma.html#pragma_reverse_unordered_selects
On Thu, Aug 24, 2017 at 5:38 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Cecil Westerhof wrote: > > 2017-08-24 11:29 GMT+02:00 Clemens Ladisch <clem...@ladisch.de>: > >> Cecil Westerhof wrote: > >>> But when I leave the ORDER BY out in this case, the result is the > same, but > >>> it looks like it is a bit faster. > >> > >> Are you sure? How does the output of EXPLAIN QUERY PLAN look like? > > > > No, I am not sure. I executed both a few times in the database browser. > > Both have widely varying used times. But at first glance it looked that > > without ORDER BY is about 2 times faster. But it is only at first glance, > > so certainly not something concrete. > > > > The explains. > > But I asked for EXPLAIN QUERY PLAN instead. :) > > > I do not really see a difference. > > The only difference is a Noop. > > > I also do not see a sort. > > Because it reads everything from an index that already is in the correct > order. > > > Regards, > Clemens > _______________________________________________ > 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