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

You should use stable page boundaries instead of cursors. If you are returning results by timestamps, the page boundary should be the timestamp and secondary ordering keys of the last row returned.

Cursors take too many server resources and require client affinity.



You’re describing cursor-based pagination. It’s got nothing to do with the SQL concept of cursors.




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

Search: