Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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



You should really read this: https://www.slideshare.net/MarkusWinand/p2d2-pagination-done...


Yep 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)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: