[SERVER-30696] $sort in aggregate is super slow Created: 16/Aug/17 Updated: 07/Sep/17 Resolved: 16/Aug/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Aggregation Framework |
| Affects Version/s: | 3.4.6 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Jesper Erik Bendtsen | Assignee: | Mark Agarunov |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Operating System: | ALL | ||||||||
| Participants: | |||||||||
| Description |
|
I have a collection with about 75.000 docs Indexes: This query takes about 1-2 milliseconds and gives 1 hit:
This query takes about 180 milliseconds and gives 1 hit:
Why is it so slow with $sort? |
| Comments |
| Comment by Mark Agarunov [ 16/Aug/17 ] |
|
Hello jesperbendtsen83@gmail.com, Thank you for the report. Looking over your description and example of the behavior, I believe this behavior has the same cause as Thanks, |