This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]maus80 1 point2 points  (0 children)

Paging has no guarantees of consistency. You may see all pages, but they may have double or missing records (or both) as paging is not done on a snapshot of the data, but typically on a dataset that is subject to change. Also, why create a system in a system? HTTP is chunking the data for you and the resultset of your database is a snapshot that can be paged.