The goal is to evaluate a proposal to correct the performance problem.
- 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.