I must implement or use functionality that enables walking via a Table in SQLite.
If I've got a Table
Products which has 100k rows, I must retrive possibly 10k rows at any given time. Somthing much like the way a web page would list data and also have a
< Previous .. Next > connect to walk-through the information.
Exist choose claims that may get this to simple? I see and also have attempted while using ROWID along with LIMIT which appears ok otherwise ordering the information.
// This appears works otherwise ordering.
SELECT * FROM Products WHERE ROWID BETWEEN x AND y;
Are you currently searching for offset and limit? SQLite supports these. After that you can use order by, which SQLite will also support.
EDIT: To elaborate, that you can do something similar to:
Select * from Products order by name limit 10000 offset 10000;
This brings the 2nd 10k page in the table, sorted by title. Be careful for performance issues when confronted with limit/offset and order by.