suneet-s commented on issue #9403: Cache value when iterating over IndexedTableColumnValueSelector URL: https://github.com/apache/druid/pull/9403#issuecomment-591048090 ``` Benchmark (query) (vectorize) Mode Cnt Score (master) Error(master) Units Score (caching) Error(caching) Delta JoinBenchmark.querySql count(*), join 3 tables FALSE avgt 3 54.185 ± 11.824 ms/op 52.683 14.109 1.502 JoinBenchmark.querySql group by 2 cols, calculate and order by sum, grou, join 2 tables on id FALSE avgt 3 116.448 ± 8.003 ms/op 122.332 23.478 -5.884 JoinBenchmark.querySql group by 1 col, calculate and order by sum, grou, join 2 tables on id FALSE avgt 3 47.609 ± 11.332 ms/op 49.626 6.763 -2.017 JoinBenchmark.querySql group by, filter on high cardinality column , join 2 tables FALSE avgt 3 14.491 ± 3.292 ms/op 14.635 2.014 -0.144 JoinBenchmark.querySql group by, filter on low cardinality column , join 2 tables FALSE avgt 3 124.18 ± 94.693 ms/op 120.294 3.943 3.886 JoinBenchmark.querySql group by, filter on low cardinality column in both tables, join 2 tables FALSE avgt 3 19.257 ± 14.601 ms/op 19.131 2.614 0.126 JoinBenchmark.querySql group by, filter on low and high cardinality, join 3 tables FALSE avgt 3 25.539 ± 13.968 ms/op 24.155 2.703 1.384 JoinBenchmark.querySql top 100 on high cardinality column, join 3 tables FALSE avgt 3 431.9 ± 59.677 ms/op 419.277 55.198 12.623 JoinBenchmark.querySql group by 2 columns, sum having greater than, join 2 tables FALSE avgt 3 227.124 ± 278.733 ms/op 194.003 26.668 33.121 ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
