So just querying for coordinates appear to be much better thanks to SERVER-17469. However, after more testing I noticed that if I include a date range in the query there is a pretty significant performance regression between 2.6 and 3.0. I've attached a second export(2d-regression-date-range.tar.gz) that is the same as the previous export but with an additional _created_at field.
2.6
millis: 81
nscanned: 35252
nscannedObjects: 20345
3.0
executionTimeMillis: 2726
totalKeysExamined: 1037671
totalDocsExamined: 744461
- depends on
-
SERVER-19039 geoNear scans the same index cells multiple times, slowing down queries with many search intervals
- Closed
- is related to
-
SERVER-17929 Add full query support for $meta values geoNearDistance/geoNearPoint
- Backlog