On Wed, Mar 16, 2011 at 3:15 PM, Travis Orr <[email protected]> wrote: > I am currently working on a project that requires retrieving a list of > all the rows from a FTS3 table. The ordering of the results varies by > search criteria. Since this is for an embedded project the list results > are passed in chunks to another module to give the appearance of faster > operations.
Somewhere you have some state information so that you know what offset to use. Store the SQLite cursor with that state information, and use it to fetch the next 2000 rows on each call, ie, only do the query once. Jim -- HashBackup: easy onsite and offsite Unix backup http://www.hashbackup.com _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
