Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination
Open link in next tab
Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination
https://ivopereira.net/efficient-pagination-dont-use-offset-limit
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