[SERVER-21312] $lookup should batch query requests Created: 05/Nov/15  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: Aggregation Framework
Affects Version/s: 3.2.0-rc2
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Charlie Swanson Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 9
Labels: optimization, perfomance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-64021 Lookup stage poor performance Closed
Related
related to SERVER-21284 $lookup should cache query results Backlog
is related to SERVER-49461 Slow performance when doing lookup in... Closed
Assigned Teams:
Query Optimization
Participants:

 Description   

The $lookup stage currently does one query per input document, which can introduce a significant amount of overhead if there are few results. Instead, the $lookup stage should batch up a couple documents and query for their results all at once.



 Comments   
Comment by Xiaoqiang Zhou [ 18/Aug/22 ]

Any plan to make this improvement?

Generated at Thu Feb 08 03:56:57 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.