-
Type: Improvement
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
Fully Compatible
-
Query 2019-12-16, Query 2019-12-30
In pipeline:
[ ... {$lookup:{}}, {$addFields:{}}, {$lookup:{}}, {$limit:10}, ... ]
moving $limit before the first $lookup stage will significantly reduce the amount of work that lookup and addFields have to do. We currently don't reorder $limit with $lookup, it appears.
- is related to
-
SERVER-27829 Reduce performance impact of DocumentSourceCursor batching
- Backlog
- related to
-
SERVER-26442 Push $sort before $project and $addFields
- Open
-
SERVER-43297 Inefficient query on view due to $limit and $skip stages not being pushed down
- Closed