A while back I was debugging an API where page 1 returned in 5ms and page 50,000 took several...
A while back I was debugging an API where page 1 returned in 5ms and page
50,000 took several seconds. Same query, same table, same indexes. The only
difference was one number in the URL.
This post is about why that happens, and how keyset pagination fixes it.
The problem with OFFSET
Your API hands out 50 records at a time across 400 pages. You need all of them. You do not need them...
Two N+1 patterns I fixed recently (the assembly loop, and an N+1 hiding inside a predicate) and the batching approach that makes…
Pagination is a key component on web-applications that let users navigate through pages making easy...
You've probably experienced this. Your app works perfectly during development. Then production...
The Hidden O(N) Pagination Trap When building data-heavy B2B SaaS platforms at Smart Tech Devs,...
Something felt slow Our product backlog list page was sluggish. Not dramatically broken —...
