MongoDB – paging

by

Using skip+limit is not a good way to do paging when performance is an issue, or with large collections; it will get slower and slower as you increase the page number. Using skip requires the server to walk though all the documents (or index values) from 0 to the offset (skip) value.

It is much better to use a range query (+ limit) where you pass in the last page’s range value. For example if you are sorting by “publishdate” you would simple pass the last “publishdate” value as the criteria for the query to get the next page of data.

More Related Contents:

  1. MongoDB: Combine data from multiple collections into one..how?
  2. MongoDB: Is it possible to make a case-insensitive query?
  3. MongoDB: count the number of items in an array
  4. How to remove a field completely from a MongoDB document?
  5. Multiple join conditions using the $lookup operator
  6. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  7. Understanding MongoDB BSON Document size limit
  8. MongoDB – admin user not authorized
  9. How can I run MongoDB as a Windows service?
  10. How do I search for an object by its ObjectId in the mongo console?
  11. MongoDB password with “@” in it
  12. exclude fields in $lookup aggregation
  13. Mongo how to $lookup with DBRef
  14. Add some kind of row number to a mongodb aggregate command / pipeline
  15. How to enforce foreign keys in NoSql databases (MongoDB)?
  16. How do you query for “is not null” in Mongo?
  17. MongoDB select count(distinct x) on an indexed column – count unique results for large data sets
  18. MongoDB sort documents by array elements
  19. MongoDB won’t start after server crash
  20. How does sorting with an index work in MongoDB?
  21. How to use dot in field name?
  22. Docker: change folder where to store docker volumes
  23. What is the maximum number of parameters passed to $in query in MongoDB?
  24. How to organise a many to many relationship in MongoDB
  25. Mongodb aggregation pipeline how to limit a group push
  26. Modify and replay MongoDB oplog
  27. Creating custom Object ID in MongoDB
  28. Return actual type of a field in MongoDB
  29. Sort nested array of objects
  30. How to create a Mongo Docker Image with default collections and data?

Leave a Comment