On 2/1/17, Igor Tandetnik <i...@tandetnik.org> wrote: > On 2/1/2017 9:50 AM, Anthrathodiyil, Sabeel (S.) wrote: >> I am facing issue with SQLite performance when having more records in the >> table and fetching from higher offsets > > https://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
See also https://www.sqlite.org/rowvalue.html#scrolling_window_queries Note that to use the row-value feature, you'll need to update to a newer version of SQLite. But you should do that anyway, since newer versions will be more than twice the speed of 3.7.10 and will be fully backwards compatible. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
