4 ms·
Anyone else notice the example query times are very high? Might just be that the example code was written on a slow machine, but I'd normally expect queries lik
by danpalmer 4y ago
Anyone else notice the example query times are very high? Might just be that the example code was written on a slow machine, but I'd normally expect queries like this to take ~10ms in production, not ~500-1500ms.
- ryanbrunner 4y agoAt a very high number of pages, LIMIT / OFFSET becomes extremely slow, even when using optimization techniques like this (although the times you're quoting are for unoptimized queries). If you routinely need to go that deep through a paginated list, you probably want to look into other techniques.