[SERVER-9521] query slow when searching for 2 identical sub documents Created: 30/Apr/13 Updated: 10/Dec/14 Resolved: 17/Jun/13 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 2.4.3 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Minor - P4 |
| Reporter: | wolf | Assignee: | David Hows |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
win 64 |
||
| Operating System: | Windows |
| Participants: |
| Description |
|
got query of type. Wed May 01 06:48:28.435 [conn348] query bauhaus.MDocument query: { $and: [ { _is Deleted: false }, { _basedOn: "$system.SearchPhraseCombination" }, { _attributes } }, { _attributes: { $elemMatch: { _basedOn: "$system.SecondaryWord", _ isDeleted: false, _valueText: "B" } } } ] } ntoreturn:0 ntoskip:0 nscanned:28007 |
| Comments |
| Comment by David Hows [ 28/May/13 ] |
|
Hi Wolf, Can you explain a little more clearly what the issue you are seeing is? It sounds like you are only seeing this query in your logs when its running slow, which is expected as MongoDB will only print queries running over the SlowMS value (default 100ms). Can you elaborate a bit, and provide explain output for both the good and bad queries? Thanks, |