1. 14
    Do not use offset and limit for pagination in PostgreSQL [2014] databases scaling chrisdone.com
    unbalancedparentheses avatar via unbalancedparentheses 1 year ago | cached | 3 comments

  1.  

  2. 1
    adsouza avatar adsouza 1 year ago | link

    Does anybody know if this is an issue with MySQL as well or not?

    1. 2
      tedu avatar tedu 1 year ago | link

      I would expect so. The obvious and perhaps only way to implement offset is linear scan.

      1. 2
        unbalancedparentheses avatar unbalancedparentheses 1 year ago | link

        Yes, same issue. Check http://use-the-index-luke.com/no-offset