[SERVER-2309] Sorting not using index properly with 3 field compound index Created: 30/Dec/10 Updated: 30/Dec/10 Resolved: 30/Dec/10 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 1.6.5 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ryan Ahearn | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
OSX |
||
| Operating System: | ALL |
| Participants: |
| Description |
|
I am getting a "too much data for sort() with no index. add an index or specify a smaller limit" error when trying to query on 2 fields and sort on a third, even when using hint and an index exists that I think should work. Full output of my .stats() and the queries in question can be found at: http://pastie.org/1417475 |
| Comments |
| Comment by Eliot Horowitz (Inactive) [ 30/Dec/10 ] |
|
See |