[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 SERVER-2148

Generated at Thu Feb 08 02:59:35 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.