3 ms·
As 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
by knorker 6y ago
As 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))