Created
February 18, 2020 04:00
-
-
Save Haleluak/f9fb8c86f4546d54b74af5b308fab8cd to your computer and use it in GitHub Desktop.
pagingnator
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Using this property of ObjectId and also taking into consideration the fact that _id is always indexed, we can devise following approach for pagination: | |
| Fetch a page of documents from database | |
| Get the document id of the last document of the page | |
| Retrieve documents greater than that id | |
| In Mongo Shell your pagination code looks something like this | |
| // Page 1 | |
| db.students.find().limit(10) | |
| // Page 2 | |
| last_id = ... # logic to get last_id | |
| db.students.find({'_id': {'$gt': last_id}}).limit(10) | |
| // Page 3 | |
| last_id = ... # logic to get last_id | |
| db.students.find({'_id': {'$gt': last_id}}).limit(10) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment