From Dev.to
Why page 800 of your list is slow (and the one-line fix)
A list endpoint with LIMIT 20 OFFSET 20000 looks harmless. On a table with a few hundred rows in development it is instant, so nobody notices. In production the database reads the first 20,000 rows in...