[SERVER-71035] Investigate regressions on simple inclusion/exclusion projections over deeply nested paths Created: 02/Nov/22  Updated: 01/Nov/23  Resolved: 18/Aug/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0

Type: Task Priority: Major - P3
Reporter: Mihai Andrei Assignee: Drew Paroski
Resolution: Fixed Votes: 0
Labels: pm2697-m3
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Problem/Incident
Related
Backwards Compatibility: Fully Compatible
Backport Requested:
v7.0
Sprint: QE 2023-05-15, QE 2023-05-29, QE 2023-06-12, QE 2023-06-26, QE 2023-07-10, QE 2023-07-24, QE 2023-08-07, QE 2023-08-21
Participants:
Linked BF Score: 135
Story Points: 10

 Description   

For example, see the following regressions:

  • Queries.FindExclusion.ProjectionDottedField.SinglePathSixComponentsNestedArraysOfSizeFive
  • Queries.FindInclusion.ProjectionDottedField.SinglePathSixComponentsNe
  • Queries.FindExclusion.ProjectionDottedField.SinglePathThreeComponentsNested
  • Queries.FindInclusion.ProjectionDottedField.SinglePathThreeComponentsNestedArraysOfSizeFive


 Comments   
Comment by Drew Paroski [ 06/Sep/23 ]

amr.elhelw@mongodb.com : Yes, I definitely think we should backport this. I planned to try to do a cherry-pick locally just to see how bad the conflicts would be and if there are any other PRs that SERVER-71035 depends on that would also need to be backported.

Comment by Githook User [ 18/Aug/23 ]

Author:

{'name': 'Drew Paroski', 'email': 'drew.paroski@mongodb.com', 'username': 'paroski'}

Message: SERVER-71035 [SBE] Improve performance of projections
Branch: master
https://github.com/mongodb/mongo/commit/58d37822a5fdc1ffa80c46c9144fb91dfc95e6cf

Comment by Drew Paroski [ 01/Jun/23 ]

Some of the refactoring from https://github.com/10gen/mongo/pull/11896/ was split off into a separate PR: https://github.com/10gen/mongo/pull/11936/ .

Also, https://github.com/10gen/mongo/pull/ is still active and I hope to update it soon (within the next week).

Comment by David Storch [ 12/Apr/23 ]

I've requested backport for 7.0 so that we don't forget. We can re-evaluate backportability once the changes land in the master branch.

Comment by Kyle Suarez [ 12/Apr/23 ]

andrew.paroski@mongodb.com, after discussion with david.storch@mongodb.com today, I am going to remove this ticket from the SBE Perf project as we've decided this is non-blocking for the 7.0 release. We will backport your change after the rc period completes and target the dot release in 7.0.1.

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