--- R S <[EMAIL PROTECTED]> wrote: > > I don't quite see why you need rowId to be contiguous > to implement your > > paging. Can't you do something like this: > > > > select * from mytable > > where rowId > :lastRowId > > order by rowId > > limit 100 > > > > OK I do it this way, but my concern was are these rows > refilled later? > Also what happens if the rowid exceeds U32? >
Wouldn't select * from mytable order by rowid limit 100 offset pgCount*100; be simpler than managing/remembering the start/last rowid for each page? FWIW, I think I read here that SQLite3 stores rowids as a 64-bit integer. -Clark