Closed gingerwizard closed 2 years ago
I tested this and it doesn't improve query performance - slightly worsening the 99% percentile and max.
----------------STATISTICS----------------
Max: 8.082517
Min: 0.007037
Median: 1.250115
Mean: 1.553253674302789
Harmonic Mean: 0.3923709413461792
95% Percentile: 3.9752856499999987
99% Percentile: 5.305239200000002
Mean Hits: 54648.72310756972
Std. dev Hits: 53867.789631131076
Max Hits: 179659
Min Hits: 0
Closing we aren't going to use. Little to no upside.
@lollobaldo adds delta encoding to positions