On Fri, Oct 7, 2011 at 5:52 PM, Simon Slavin <slav...@bigfraud.org> wrote: > Okay, I understand why defining an ORDER BY requires the entire result set to > be retrieved. I had intended to remove ORDER BY when I used COUNT(*), though > I didn't mention that.
If the ORDER BY can be satisfied entirely by an index, then that's not true. You can see whether this is the case from the query plan. So you could reject queries for which you can't use OFFSET & LIMIT efficiently. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
