[SERVER-72803] Cache hinted SBE queries Created: 12/Jan/23  Updated: 29/Oct/23  Resolved: 16/Mar/23

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

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

Issue Links:
Duplicate
is duplicated by SERVER-66946 Cache SBE plans for queries that spec... Closed
Problem/Incident
Related
is related to SERVER-71038 Investigate LLT mixed regressions Backlog
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-02-06, QE 2023-02-20, QE 2023-03-06, QE 2023-03-20
Participants:
Linked BF Score: 35
Story Points: 5

 Description   

This ticket captures the work to allow hinted queries to use the SBE plan cache. The thinking here is that hinted queries can benefit greatly perf wise from being cached.



 Comments   
Comment by Githook User [ 16/Mar/23 ]

Author:

{'name': 'Zixuan Zhuang', 'email': 'zixuan.zhuang@mongodb.com', 'username': 'leozzx'}

Message: SERVER-72803 cache hinted sbe query
Branch: master
https://github.com/mongodb/mongo/commit/c12eaa0d7ef85dbdda70095c873728936e3e6ea5

Comment by Ivan Fefer [ 03/Mar/23 ]

Should it improve the performance for this queries from LLTMixed workload as well? 
SERVER-74113

Comment by David Storch [ 15/Feb/23 ]

Yeah, they're dupes. We should close one of them. Do you prefer to close this one or to close SERVER-66946?

Comment by Mihai Andrei [ 15/Feb/23 ]

Note that (I think) this duplicates https://jira.mongodb.org/browse/SERVER-66946

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