Tag

#Pagination

Every article tagged Pagination, in one place.

2 articles
3 min of reading
10 Jun, 2026 last updated

Showing 2 articles

MySQL 2 min read

Fast Pagination in MySQL with Keyset Pagination

LIMIT 20 OFFSET 100000 looks innocent, but MySQL must read and throw away 100,000 rows to return 20. Deep pages get slower and slower. The problem SELECT id, title, created_at FROM posts ORDER BY created_at DESC, id DESC LIMIT 20 OFFSET 100000; -- reads 100,02...

10 Jun, 2026 Author 524 78

Read article

MongoDB 1 min read

Paginating and Optimising MongoDB Queries

skip() and limit() are the obvious way to paginate, but skip(100000) still walks past 100,000 documents. Range-based pagination keeps every page equally fast. Range (keyset) pagination // First page const page = await posts .find({ status: 'published' }) .sort...

16 Apr, 2026 Author 174 132

Read article