4 ms·
How does keyset based pagination deal with deletes? If the cursor/current key is deleted you lose your paging state. Or am I wrong?
by ablol 5y ago
How does keyset based pagination deal with deletes? If the cursor/current key is deleted you lose your paging state. Or am I wrong?
- inshadows 5y agoAFAU you use keyset as upper/lower bounds in your SQL query, so deletion is not problem. Example: Cursor ($ID:$DATE) = "123:2012-01-01" Query: select * from tbl where id >= $ID and date >= $DATE limit 100