If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it
deleted by creator
For the article-impaired,
Using OFFSET+LIMIT for pagination forces a full table scan, which in large databases is expensive.
The alternative proposed is a cursor+based navigation, which is ID+LIMIT and requires ID to be an orderable type with monotonically increasing value.
Which it almost never is.
Any data as simple as that is unlikely to reach a number of rows likely to cause an issue with performance.
Account-wall. Please provide a link that doesn’t force me to make an account.
Sorry, link updated
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?
Still wants me to make an account.
That’s really weird, because I have no account on medium and it works for me. Maybe try this link instead:
https://ivopereira.net/efficient-pagination-dont-use-offset-limit
