You’re right about the offset problem, I guess that could be optimized somewhat by caching, then again for google 90% of search likely won’t hit any db at all.

You’re right about the offset problem, I guess that could be optimized somewhat by caching, then again for google 90% of search likely won’t hit any db at all. Going to the next 10 isn’t as costly as sorting the next 1000. Which is likely why pagination are limited at that. It’s easy to not do offset and tokenize every single entry for a small amount of range and present it as the same kind of pagination.