Details
-
Improvement
-
Resolution: Fixed
-
Major - P3
-
None
-
Fully Compatible
-
Query 2019-12-16, Query 2019-12-30
Description
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.
Attachments
Issue Links
- 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
-