CODEWITHSUNDEEP
node.jsmongodbsortingpaginationmongoose
Zeke Nierenberg
Zeke Nierenberg

Reputation: 2196

Alternative to skip and limit for mongoose pagination with arbitrary sorting

Let me start by saying that I've read (MongoDB - paging) that using skip and limit for pagination is bad for performance and that its better to sort by something like dateCreated and modify the query for each page.

In my case, I'm letting the user specify the parameter to sort by. Some may be alphabetical. Specifying a query for this type of arbitrary sorting seems rather difficult.

Is there a performance-friendly way to do pagination with arbitrary sorting?

Example

mongoose.model('myModel').find({...})
        .sort(req.sort)
        ...

Secondary question: At what scale do I need to worry about this?

Upvotes: 2

Views: 3705

Answers (1)

Ostro
Ostro

Reputation: 338

i don't think you can do this.

but in my opinion the best way is to build you query depending on your req.sort var. for example (it's written in coffescript)

userSort = {name:1} if req.sort? and req.sort="name"
userSort = {date:1} if req.sort? and req.sort="date"
userSort = {number:1} if req.sort? and req.sort="number"


find {}, null , {skip : 0 , limit: 0, sort : userSort } , (err,results)->

Upvotes: 2

Related Questions