MongoDB โ Sorting, Limiting & Pagination
Sort results with .sort(), limit counts with .limit(), and build offset vs keyset pagination.
1Sorting & Limiting Syntax
Sort & Limit
// Sort by age ascending (1), then score descending (-1)
db.users.find().sort({ age: 1, score: -1 }).limit(10);
2Pagination: Offset (skip/limit) vs Keyset
Pagination Examples
// Offset Pagination (Page 3, 10 items per page)
db.users.find().skip(20).limit(10);
// Keyset Pagination (Faster on large data)
db.users.find({ _id: { $gt: lastSeenId } }).limit(10);