[SERVER-84819] geo performance issue in 2.7.7 Created: 06/Aug/14  Updated: 12/Jan/24  Resolved: 30/Oct/14

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Rui Zhang (Inactive) Assignee: Unassigned
Resolution: Done Votes: 0
Labels: 28qa
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-15450 Avoid getStats() and keep interval st... Closed
depends on SERVER-15451 Adaptive initial shell in near query ... Closed
depends on SERVER-15363 Timer use in stages slows down queries Closed
Duplicate
is duplicated by SERVER-15452 Create Performance Parity between 2.6... Closed
Related
related to SERVER-9986 Refactor $geoNear searches into new q... Closed
is related to SERVER-15455 Search inner covering first for geoWi... Backlog
Participants:

 Description   

there are some issue with $geoNear performance with SHA 2cbd9f1d77ce6b25e9957d3121fccb521caf848f



 Comments   
Comment by Siyuan Zhou [ 30/Oct/14 ]

With density estimation, most of the cases related this issue should be solved.

Comment by Siyuan Zhou [ 06/Aug/14 ]

The labeling in test code seems confusing. It is would be better to name this case "Geo.geoNear.2d.findOne.nearSphere.center" since it's not using 2dsphere index. Also it might be interesting to see the performance with 2dsphere index.

Comment by Greg Studer [ 06/Aug/14 ]

Just to clarify for myself and everyone else, in order of time (most recent to oldest):

2cbd9f1d77ce6b25e9957d3121fccb521caf848f - SERVER-5800 changes for geo expression index performance
^ Performance fixes for geoNear and geoWithin

3c5246b1fb2ec2f9c34ba1cb5083b2745d7bdf89 - SERVER-9986 refactor near search for 2D and S2
^ The patch with geoNear refactor in v2.7

6537dc777512d093a489cb1db99e8db8cf50b914 - SERVER-5800 convert 2d predicate queries into covered index scan
^ The patch with expression index refactor for geoWithin in v2.7

Not much tuning has been done yet for the geoNear refactor.

Generated at Thu Feb 08 06:56:05 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.