-
Type: Task
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Execution
As part of SERVER-79181 we introduce QuerySettings into PlanCacheKey. PlanCacheKey has a planCacheKeyHash() method that is used to compute hash of the key.
Now when computing the hash, hash of the QuerySettings is also computed and then later combined and returned.
We could avoid hash computation of QuerySettings as part of the planCacheKeyHash() as its hash can be computed once as part of setQuerySettings, cached in QuerySettingsManager and then later returned as part of the QuerySettings lookup.
This way QuerySettings hash value will be computed only once, which should improve the overall performance on the hot path.
First we need to profile to check how much time is spent computing the hash and then decide whether or not it is worth caching it
- is related to
-
SERVER-79181 Apply QuerySettings for find commands
- Closed
- related to
-
SERVER-80937 Avoid linear lookup for allowed indexes in applyQuerySettings()
- Backlog