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