Ken Krugler
12/11/2020, 1:26 AMMayank
1. Very high read qps (> 10k)
2. Very low read latency SLA (p99 < 100ms)
3. Long queries with too many values in IN clause for a string column.
In such cases, we found that a lot of time was spent in off-heap dict lookup to find dict id's for those strings, and that resulted in too many String deserializations (from byte-buffer) that was slow as well as generated garbage.Mayank