[SERVER-57123] Improve performance of ExpressiveQueries workload in SBE Created: 21/May/21  Updated: 29/Oct/23  Resolved: 10/Feb/23

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

Type: Improvement Priority: Major - P3
Reporter: Nikita Lapkov (Inactive) Assignee: Ivan Fefer
Resolution: Fixed Votes: 0
Labels: pm2697-63, pm2697-m3
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
Related
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-02-06, QE 2023-02-20
Participants:
Linked BF Score: 35
Story Points: 10

 Comments   
Comment by Githook User [ 10/Feb/23 ]

Author:

{'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}

Message: SERVER-57123 Reduce number of fillEmpty false in sbe_stage_builder_filter.cpp
Branch: master
https://github.com/mongodb/mongo/commit/ce925dfbbc9459f65b1ad6f91a2d85c02ab69ca4

Comment by Githook User [ 08/Feb/23 ]

Author:

{'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}

Message: SERVER-57123 Split field accessor map by bloom filter offset
Branch: master
https://github.com/mongodb/mongo/commit/2b8312d6f28abe4b5b2a5af0b0faea2963db8496

Comment by Ivan Fefer [ 25/Jan/23 ]

After fixing memory leak in the workload, local runs suggest roughly equal performance by SBE and classic. Let's wait a couple of days for dashboard to catch up and re-evaluate the results.

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