[SERVER-78485] $project after $search adds 20x latency Created: 27/Jun/23 Updated: 14/Sep/23 |
|
| Status: | In Progress |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Evan Darke | Assignee: | Will Buerger |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | greenerbuild, quick-tech-debt | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
| Assigned Teams: |
Query Integration
|
| Operating System: | ALL |
| Sprint: | QI 2023-07-24, QI 2023-08-07 |
| Participants: |
| Description |
|
Adding a $project stage should not add significant overhead but:
$project itself isn't slow though because the same query with a really large limit is very fast
Use cases:
|
| Comments |
| Comment by Evan Darke [ 25/Jul/23 ] |
|
kyle.suarez@mongodb.com Unfortunately I think I've only tried this on sharded clusters running 6.0 |