[
https://issues.apache.org/jira/browse/IGNITE-24893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Korotkov resolved IGNITE-24893.
--------------------------------------
Resolution: Not A Bug
> 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}value{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}15.64{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}62.93{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}131.69{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}7.60{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}1,272.75{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}0.93{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)
