On Thu, 1 Oct 2015 13:40:23 +0200, Clemens Ladisch <clemens at ladisch.de> wrote:
> OFFSET is inefficient because the database still has to compute all the > rows before skipping over them. > > To do paging, remember the first and last date values on the page, and > for the previous/next page, just continue from there: > > SELECT ... > FROM MyTable > WHERE date > :LastDateOnPreviousPage > ORDER BY date > LIMIT 25; > > (If dates are not unique, you have to use more columns.) Indeed. More info on this technique: http://sqlite.org/cvstrac/wiki?p=ScrollingCursor (page is obsolete but still works) -- Regards, Kees Nuyt
