[SERVER-66457] Large $elemMatch queries are slow in SBE Created: 13/May/22 Updated: 27/Oct/23 Resolved: 28/Feb/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Kyle Suarez | Assignee: | Martin Neupauer |
| Resolution: | Gone away | Votes: | 0 |
| Labels: | pm2697-63, pm2697-m3, sbe | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||
| Operating System: | ALL | ||||||||||||
| Sprint: | QE 2023-02-06, QE 2023-02-20, QE 2023-03-06 | ||||||||||||
| Participants: | |||||||||||||
| Story Points: | 5 | ||||||||||||
| Description |
|
Summary: The performance of $elemMatch in SBE scales very poorly as the number of elements in the query grows, and the regression appears to grow unbounded (as compared with the classic engine. |
| Comments |
| Comment by Mihai Andrei [ 28/Feb/23 ] |
|
Closing this as gone away since $elemMatch now performs better in SBE than in classic |
| Comment by Kyle Suarez [ 28/Sep/22 ] |
|
This ticket an amalgamation of many different issues that we think will be addressed by other work in the SBE Perf epic. We will rerun $elemMatch benchmarks after a few other tickets land. |