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?
It is rather difficult to force SQLite into a situation where it assigns
non-increasing ids - essentially, you have to either overflow 64-bit
counter, or explicitly create a row with the id of 2^64-1. If you don't
want to take any chances, declare the column with autoincrement keyword.
For more details, see
http://www.sqlite.org/autoinc.html
Igor Tandetnik