9 ms·
How about "do not use offset for pagination"? http://use-the-index-luke.com/no-offset http://use-the-index-luke.com/no-offset
by MarkusWinand 9y ago
How about "do not use offset for pagination"?
http://use-the-index-luke.com/no-offset http://use-the-index-luke.com/no-offset
- jarulraj 9y agoSure :) Any other interesting suggestions? I must mention that I greatly admire your pragmatic books on improving database performance, and they were a source of inspiration for the development of this tool.
- combatentropy 9y agoA complicated solution to something that is not a problem, at least for my lowly business CRUD apps.
- yellowapple 9y agoI feel like the author unjustly brushes aside the main benefit of using offsets for pagination (that is: the ability to query a specific page of results). Yeah, most page-based UIs do a lame job at it, but it's nice to be able to say "yeah, the record you want is on the fourteenth row of page 9". If that's not a relevant use case for your application, though, then by all means use key-set pagination. As a side note, I happen to dislike most implementations of infinite scrolling (especially when the keep pushing down the page footer, making it impossible to actually read or click on anything down there... GRRRR!).