Details
-
Sub-Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Do
-
None
-
None
-
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.