How to paginate with Mongoose in Node.js?

by

I’m am very disappointed by the accepted answers in this question. This will not scale. If you read the fine print on cursor.skip( ):

The cursor.skip() method is often expensive because it requires the server to walk from the beginning of the collection or index to get the offset or skip position before beginning to return result. As offset (e.g. pageNumber above) increases, cursor.skip() will become slower and more CPU intensive. With larger collections, cursor.skip() may become IO bound.

To achieve pagination in a scaleable way combine a limit( ) along with at least one filter criterion, a createdOn date suits many purposes. 

MyModel.find( { createdOn: { $lte: request.createdOnBefore } } )
.limit( 10 )
.sort( '-createdOn' )

More Related Contents:

  1. Node.js Mongoose.js string to ObjectId function
  2. mongoDB/mongoose: unique if not null
  3. Mongoose Unique index not working!
  4. How do you use Mongoose without defining a schema?
  5. How to access a preexisting collection with Mongoose?
  6. How do I query for distinct values in Mongoose?
  7. MongoDB password with “@” in it
  8. How to return Mongoose results from the find method?
  9. MongoDB: output ‘id’ instead of ‘_id’
  10. How can I update multiple documents in mongoose?
  11. Mongoose’s find method with $or condition does not work properly
  12. Delete a key from a MongoDB document using Mongoose
  13. Can’t find documents searching by ObjectId using Mongoose
  14. What’s Mongoose error Cast to ObjectId failed for value XXX at path “_id”?
  15. Populate nested array in mongoose
  16. Why does mongoose always add an s to the end of my collection name
  17. Mongoose Schema hasn’t been registered for model
  18. Mongoose findByIdAndUpdate not returning correct model
  19. Mongoose duplicate key error with upsert
  20. How can I use a cursor.forEach() in MongoDB using Node.js?
  21. Mongoose update without callback
  22. Mongoose subdocuments vs nested schema
  23. Image returned from REST API always displays broken
  24. Model.find().toArray() claiming to not have .toArray() method
  25. Mongoose limit/offset and count query
  26. How can I save multiple documents concurrently in Mongoose/Node.js?
  27. How do I increment a Number value in Mongoose?
  28. How to reference another schema in my Mongoose schema?
  29. How to do pagination using range queries in MongoDB?
  30. MongooseError: Model.findOne() no longer accepts a callback at Function

Leave a Comment