Why You Shouldn't Use OFFSET and LIMIT For Your Pagination
ivopereira.net
Gone are the days when we wouldn’t need to worry about database performance optimization.

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

  • Blackmist@lemmy.worldEnglish
    2·
    11 months ago

    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.