What is Cursor pagination?
Loading the next page by asking for rows after the last one you saw, instead of skipping a count of rows. Stays fast on huge tables.
Learn it properly
Chapter 9: The Diwali Dress Rehearsal
Database design that stays fast: schemas, indexes, N+1
Read chapter 9 →