[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: |
|
||||||||||||||||||||
| 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: |
| Comment by Ivan Fefer [ 03/Mar/23 ] |
|
Should it improve the performance for this queries from LLTMixed workload as well? |
| 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 |
| Comment by Mihai Andrei [ 15/Feb/23 ] |
|
Note that (I think) this duplicates https://jira.mongodb.org/browse/SERVER-66946. |