3 ms·
See also: http://use-the-index-luke.com/no-offset http://use-the-index-luke.com/no-offset
by barsonme 9y ago
See also: http://use-the-index-luke.com/no-offset http://use-the-index-luke.com/no-offset
- thriftwy 9y agoBut how would you build a paginator? How would you give a link to page 9 when you're on page 1?
- icebraining 9y agoYou can't: On slide 43 you can also see that keyset pagination has some limitations: most notably that you cannot directly navigate to arbitrary pages. However, this is not a problem when using infinite scrolling. Showing page number to click on is a poor navigation interface anyway—IMHO. As someone who often skips a few pages when navigating such interfaces, I say "thanks, but no thanks".
- deleted 9y ago[deleted]
- nitely 9y agoAlso http://use-the-index-luke.com/sql/partial-results/fetch-next-page http://use-the-index-luke.com/sql/partial-results/fetch-next... for the actual keyset paging (aka the seek method) technique. Which gives a better explanation than the OP's article IMO.