Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination
Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination
ivopereira.net Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination
LIMIT and OFFSET have been misused for years for building Paginations for APIs. Learn here How To Improve Your Pagination Performance.
If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it
You're viewing a single thread.
17
comments
Is there a way I can access this article without making an account?
I'm not going to make an account.
Sorry for inconvenience, I updated the link
Oh thanks mate 👍
Interesting article but I kinda fail to see how you'd go if your paginating through sorted rows - you'd have to have an id in the sequence of your sort order?
You've viewed 17 comments.