Well, the obvious answer is to use OFFSET and LIMIT … but of course that might 
slow down too much as the page number increases.

Or you could avoid the need for pagination by leaving the statement active 
between page-loads, and just reading another N rows out of it to jump to the 
next page. (Doesn’t help you when jumping backwards, though. You could cache a 
list of rowids to regenerate previous pages from.)

—Jens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to