[SERVER-77427] Avoid going through the network when a shard is targeting only itself for a $lookup subpipeline Created: 24/May/23 Updated: 10/Jan/24 Resolved: 17/Aug/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.1.0-rc0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Hana Pearlman | Assignee: | Ivan Fefer |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | pm3229-m1 | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||||||||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||||||||||||||||||
| Backport Requested: |
v7.0, v6.0
|
||||||||||||||||||||||||||||||||||||
| Sprint: | QO 2023-06-12, QO 2023-06-26, QO 2023-07-10, QO 2023-08-07 | ||||||||||||||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||||||||||||||
| Linked BF Score: | 135 | ||||||||||||||||||||||||||||||||||||
| Description |
|
This is meant to be a targeted improvement specific to $lookup, though depending on the implementation it could affect other commands which use sharded_agg_helpers::attachCursorToPipeline, similar to |
| Comments |
| Comment by Githook User [ 26/Sep/23 ] |
|
Author: {'name': 'Rushan Chen', 'email': 'rushan.chen@mongodb.com', 'username': 'ruchen'}Message: |
| Comment by Katya Kamenieva [ 17/Aug/23 ] |
|
🎉 |
| Comment by Githook User [ 16/Aug/23 ] |
|
Author: {'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}Message: |
| Comment by David Storch [ 31/Jul/23 ] |
|
We should be able to apply this "local reads" optimization for the inner side of $lookup for the following cases:
|