Tagged Questions
2
votes
1answer
259 views
MongoDB geospatial query with sort - performance issues
I have query (which is very slow ~2,5s):
db.markers.find({ latlng: { '$within': { '$box': [ [ -16, -140 ], [ 75, 140 ] ] } } }).sort({_id: -1}).limit(1000)
When I run explain for this query I get
...
0
votes
1answer
115 views
The sort column must be the last column used in the index - MongoDB Indexing Advice
MongoDB docs advices that:
The sort column must be the last column used in the index
Here is the example:
db.foo.ensureIndex({a: 1, b: 1, c: 1})
Good:
find(a=1).sort(a)
find(a=1).sort(b)
...
