Loading...

XML

Word

Printable

JSON

Details

Type: Improvement
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 4.3.3
Affects Version/s: None
Component/s: Aggregation Framework
Labels:
- QFB
- asya
- neweng
- optimization
- performance
- qopt-team
- storch

Backwards Compatibility:
Fully Compatible
Sprint:
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

Activity

People

Assignee:: Katherine Wu (Inactive)

Reporter:: Asya Kamsky

Participants:: Asya Kamsky, David Storch, Githook User, Katherine Wu

Votes:: 1 Vote for this issue

Watchers:: 14 Start watching this issue

Dates

Created:: Sep 13 2017 05:06:32 AM UTC

Updated:: Oct 30 2023 11:13:39 PM UTC

Resolved:: Dec 17 2019 04:27:43 PM UTC