How to paginate in a subset of MongoDB result

Asked Oct 26 '13 at 05:15

Active Oct 26 '13 at 05:15

Viewed 176 times

I've got 1 million entries in a collection. After my query I receive 500 entries for user_id = X. I am looking now for one entry of this subset and 5 before and 5 after this item. What would be best strategy?

For the beginning I just select the 500 items: db.items.find({"user_id": 1}).limit(500);

I could now loop through 500 items to find my current item but it seems to me very inconvenient. Is there maybe a better way?

asked Oct 26 '13 at 05:15

hazelnut

I think you may want to look at this for inspiration: http://stackoverflow.com/questions/9703319/mongodb-ranged-pagination – Buzz Moschetti Oct 26 '13 at 15:31
what determines your "current" or single entry of this subset? – Asya Kamsky Oct 27 '13 at 03:04

How to paginate in a subset of MongoDB result

0 Answers0