[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: |
|
||||||||||||||||||||
| 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? |