3 ms·
Is an auto increment sequential number good enough for a 'cursor' or is there something I'm missing here.
by pram 6y ago
Is an auto increment sequential number good enough for a 'cursor' or is there something I'm missing here.
- knorker 6y agoAs long as it can be used to "seek" directly into where the last page ended. The problem with offset and limit is that you have to actually find the previous N results in order to get the N+1th. But with a cursor you can just "continue". (when I say "seek" I mean use indexes. I'm comparing to listing a tar file (requires reading the whole thing to find the file in the middle) vs zipfile (seek to where the file is, and read))