[
https://issues.apache.org/jira/browse/IGNITE-24893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Korotkov updated IGNITE-24893:
-------------------------------------
Labels: ise tpch (was: )
> Calcite. TPC-H query #11: performance drop after IGNITE-24721
> -------------------------------------------------------------
>
> Key: IGNITE-24893
> URL: https://issues.apache.org/jira/browse/IGNITE-24893
> Project: Ignite
> Issue Type: Task
> Reporter: Sergey Korotkov
> Priority: Major
> Labels: ise, tpch
>
> Load tests show that after the IGNITE-24721 latency and throughput of TPC-H
> query #11 drop almost two times:
>
> | ** | ** | ** | ** | ** |*{color:#000000}ignite-dev-921d41e285{color}*| ** |
> ** |*{color:#000000}ignite-dev-601c4ff826{color}*| ** | ** | ** |
> |*{color:#000000}benchmark{color}*|*{color:#000000}distr{color}*|*{color:#000000}engine{color}*|*{color:#000000}scale{color}*|*{color:#000000}metric{color}*|*{color:#000000}value{color}*|*{color:#000000}error%{color}*|*{color:#000000}runs#{color}*|*{color:#000000}value{color}*|*{color:#000000}error%{color}*|*{color:#000000}runs#{color}*|*{color:#000000}dif%{color}*|
> |{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.01{color}|{color:#000000}latency_mean_ms{color}|{color:#000000}8.73{color}|{color:#000000}±14.95%{color}|{color:#000000}4{color}|{color:#000000}15.64{color}|{color:#000000}±5.24%{color}|{color:#000000}3{color}|{color:#000000}+79.08%{color}|
> |{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.01{color}|{color:#000000}throughput_rps{color}|{color:#000000}112.95{color}|{color:#000000}±13.99%{color}|{color:#000000}4{color}|{color:#000000}62.93{color}|{color:#000000}±5.26%{color}|{color:#000000}3{color}|{color:#000000}-44.28%{color}|
> |{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.1{color}|{color:#000000}latency_mean_ms{color}|{color:#000000}62.14{color}|{color:#000000}±4.68%{color}|{color:#000000}4{color}|{color:#000000}131.69{color}|{color:#000000}±1.22%{color}|{color:#000000}3{color}|{color:#000000}+111.94%{color}|
> |{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.1{color}|{color:#000000}throughput_rps{color}|{color:#000000}16.05{color}|{color:#000000}±4.96%{color}|{color:#000000}4{color}|{color:#000000}7.60{color}|{color:#000000}±0.00%{color}|{color:#000000}3{color}|{color:#000000}-52.65%{color}|
> |{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}1.0{color}|{color:#000000}latency_mean_ms{color}|{color:#000000}703.76{color}|{color:#000000}±5.91%{color}|{color:#000000}4{color}|{color:#000000}1,272.75{color}|{color:#000000}±6.47%{color}|{color:#000000}3{color}|{color:#000000}+80.85%{color}|
> |{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}1.0{color}|{color:#000000}throughput_rps{color}|{color:#000000}1.54{color}|{color:#000000}±17.61%{color}|{color:#000000}4{color}|{color:#000000}0.93{color}|{color:#000000}±30.73%{color}|{color:#000000}3{color}|{color:#000000}-39.30%{color}|
>
> Can be locally reproduced in Jmh test
> https://github.com/apache/ignite/blob/master/modules/benchmarks/src/main/java/org/apache/ignite/internal/benchmarks/jmh/sql/tpch/TpchBenchmark.java
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
