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.