-
Type: Improvement
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
-
Query 2017-05-29, Query 2019-10-21, Query 2019-11-04, Query 2019-11-18, Query 2019-12-02, Query 2019-12-16
At present, sort key generation is very very slow, and dominates the running time for any blocking sort in the query system. The overall query blocking sort implementation is nearly an order of magnitude slower than aggregation's blocking sort. If we could speed up query's sort, we could always push down initial aggregation $sort into the query system, which would allow us to fix issues like SERVER-7568.
This ticket is to track various optimization fixes to sort key generation.
- split to
-
SERVER-44383 Use trivial BSON conversion for sort key generation
- Closed