3 ms·
Is this limitation exclusive to MySQL or does it affect Postgres as well?
by fareesh 4y ago
Is this limitation exclusive to MySQL or does it affect Postgres as well?
- e12e 4y agoSome discussion on (some) options for pagination with postgres: https://www.citusdata.com/blog/2016/03/30/five-ways-to-paginate/ https://www.citusdata.com/blog/2016/03/30/five-ways-to-pagin... Somewhat related I also came across this: https://www.datadoghq.com/blog/100x-faster-postgres-performance-by-changing-1-line/ https://www.datadoghq.com/blog/100x-faster-postgres-performa... I wonder a bit about the actual time for queries in the submitted article - seconds for a few thousands of lines of limit..offset seems terribly slow? (any query over tens/50ms I would generally call slow - in this context - displaying some data to a human)?