[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:
Related
is related to SERVER-60715 Access of array fields is slow in SBE... Closed
is related to SERVER-60724 Filter with a complex logical express... Closed
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.

Generated at Thu Feb 08 06:05:29 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.