[SERVER-802] Query optimization is doing a big scan for searches involves $in Created: 22/Mar/10 Updated: 12/Jul/16 Resolved: 16/Jul/10 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 1.3.4 |
| Fix Version/s: | 1.5.5 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Alex Dong | Assignee: | Aaron Staple |
| Resolution: | Done | Votes: | 1 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Mac OSX 10.5.8 |
||
| Attachments: |
|
||||||||||||
| Issue Links: |
|
||||||||||||
| Participants: | |||||||||||||
| Description |
|
As described in http://bit.ly/bURxwn > db.hits.findOne() { "_id":ObjectId("4ba5a0409a59dc523d0a81dc"), { Eliot replies: right now its not looking all all the sub-regions, just going from the front to back we can optimize at some point |
| Comments |
| Comment by auto [ 16/Jul/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by auto [ 16/Jul/10 ] |
|
Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'}Message: |
| Comment by Aaron Staple [ 22/Mar/10 ] |
|
We'll fix this, but for now you can get better index bounds if the $in key is first in your index – eg an index on {w:1,d:1} |
| Comment by Alex Dong [ 22/Mar/10 ] |
|
Here is a test case for this case. Thanks a lot. |