-4
Why You Shouldn’t Use OFFSET and LIMIT For Your Pagination (ivopereira.net)
submitted 2 years ago* (last edited 2 years ago) by to c/programming@programming.dev
17 comments fedilink hide all child comments
 

If you are wondering why lemmy is moving away from offset pagination since 0.19, here is a nice article about it

you are viewing a single comment's thread
view the rest of the comments
[–] 6 points 2 years ago

Lemmy just implemented it for 0.19 and it makes a big difference on heavier queries like Scaled homepage.

It also has the advantage of your pagination not getting screwy if new content has been added between page 2 and 3 queries.

  • permalink
  • fedilink
  • source
  • parent