Details
-
Type:
Sub-Task
-
Status: Open (View Workflow)
-
Priority:
Critical
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: 23.02
-
Component/s: None
-
Labels:None
-
Sprint:2021-7, 2021-8, 2021-9, 2021-10, 2021-11, 2021-12
Description
The goal is to evaluate a proposal to correct the performance problem.
The method:
- create a test version of latin1_nopad_bin collation function which would use MURMUR.
- measure the difference in performance (the expectation is 2x vs current 6x).
- compare behavior of aggregate queries which use so updated collation against:
a) original CS method - present in 1.2
b) current - as in 5.5.2
The last should be done using both flights (30 million rows) and Quinnstreet (1 billion rows).
Once we have the facts, we will be making a decision on what to do.