Re:Pagination 101
by calpaterson on Tuesday February 02, 2016 @03:07AM
(#11018169)
Doing it this way is known as the seek method/"keyset pagination" and it's also quicker when you're quite deep in the list:
http://use-the-index-luke.com/sql/partial-results/fetch-next...
So instead, when showing items 1-10, the link for the next page of results should query for the next page full of items start after item 10.
That still lets the user miss added items (mostly unavoidable unless the list is sorted by "things the user hasn't seen yet"), but doesn't miss items when deleting seen items.