presto icon indicating copy to clipboard operation
presto copied to clipboard

Published 20 hours ago • verified publisher icon Teradata

Join reordering stats11 speedup

Open sopel39 opened this issue 7 years ago • 1 comments

Using dedicated cache for join stats

After:

Benchmark                                                  (joinReorderingStrategy)  (numberOfTables)  Mode  Cnt     Score     Error  Units
BenchmarkReorderJoinsConnectedGraph.benchmarkReorderJoins                COST_BASED                10  avgt   30  5814,628 ± 188,457  ms/op

Before:

Benchmark                                                  (joinReorderingStrategy)  (numberOfTables)  Mode  Cnt      Score      Error  Units
BenchmarkReorderJoinsConnectedGraph.benchmarkReorderJoins                COST_BASED                10  avgt   10  25232,545 ± 1046,160  ms/op

sopel39 avatar Jul 05 '17 12:07 sopel39

Waiting for reorder joins to pass tests then I will merge into reorder joins branch

sopel39 avatar Jul 10 '17 13:07 sopel39