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

  • Blackmist@lemmy.worldEnglish
    2·
    7 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.