3 ms·
If page numbers are important to you, then you have to find a different method anyway because of the drifting issue.
by Gracana 11y ago
If page numbers are important to you, then you have to find a different method anyway because of the drifting issue.
- sanderjd 11y agoOr just accept that the page won't be exactly "right", but close. The solution proposed in the article doesn't have a "good enough" option for pages, as far as I can tell.
- elithrar 11y agoIf you can use cursor-based pagination, then definitely do so—but as you point out, you can't always do that. Further, unless you're using bigserials (i.e. incrementing ints), you can't check $last_seen_ID either. With UUIDs (whether v4 or a custom impl.) there's no way to check `WHERE id > $last_seen_id`.