4 ms·
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 or
by akvadrako 5y ago
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.
- JimDabell 5y agoYou’re describing cursor-based pagination. It’s got nothing to do with the SQL concept of cursors.