3 ms·
for when everything else is equal, you need something to let you get consistent sorting in your output For example, if your page size is N and you have N+1 thi
by fooey 9y ago
for when everything else is equal, you need something to let you get consistent sorting in your output
For example, if your page size is N and you have N+1 things with the same timestamp, you need a backup sort key or your pagination breaks down
- ahachete 9y agoYou should really read this: https://www.slideshare.net/MarkusWinand/p2d2-pagination-done-the-postgresql-way https://www.slideshare.net/MarkusWinand/p2d2-pagination-done...
- whateveracct 9y agoYep the Seek Method for pagination as suggested there would cause you to be sorting by UUID. SELECT uuid FROM t where filterable_field > $whatever and uuid > $lastSeen limit $pageSize with a covering index on (filterable_field, uuid)