MongoDb Range Query on ObjectId

Question

I had like to know if somebody knows if it is possible to query the _id field with a query like this :

{$lte : ObjectId(....) , $gte : ObjectId(...)

, instead of

{$in : [ObjectId( )...lots of ObjectId.....]}

and if there is a gain in performance (i think so..)

Thanks

Abhishek Kumar · Accepted Answer · 2013-06-14 07:51:50Z

6

{$lte : ObjectId(....) , $gte : ObjectId(...)

Yes there is such query {_id : {$lte : ObjectId(....) , $gte : ObjectId(...)} }

The performance depends on what is the range that you have selected in 1st query. Smaller range means fast response. For 2nd query, response depends on count and range of ObjectIds in the query. The more fragmentation in the value of ObjectIds may incur large no of page faults.

answered Jun 14, 2013 at 7:51

Abhishek Kumar

3,3662 gold badges20 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

texas-bronius Over a year ago

I edited Abhishek's excellent answer, putting $gte to the left and $lte to the right, as it is an inclusive range. I'm also making a mention here as a comment since this is a 5 year old solution, and my suggestion may not make it past moderation backlogs :D Thanks for your very helpful reply.

Collectives™ on Stack Overflow

MongoDb Range Query on ObjectId

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related