[
https://issues.apache.org/jira/browse/IGNITE-25129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Steshin updated IGNITE-25129:
--------------------------------------
Description:
_TpchBenchmark_ with build at 31.03.2025, the query q5 and scale 0.01 shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached H2 5 0.01 avgt 3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01 ss 805.308
ms
{code}
Current code shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt 3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01 ss 1786.908
ms/op
{code}
Workarounds:
{code:java}
/*+ ENFORCE_JOIN_ORDER */, /*+ NO_NL_JOIN +/
{code}
was:
`TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached H2 5 0.01 avgt 3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01 ss 805.308
ms
{code}
Current code shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt 3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01 ss 1786.908
ms/op
{code}
Workarounds:
{code:java}
/*+ ENFORCE_JOIN_ORDER */, /*+ NO_NL_JOIN +/
{code}
> Calcite. TPC-H query #5: performance drop on scale 0.01
> -------------------------------------------------------
>
> Key: IGNITE-25129
> URL: https://issues.apache.org/jira/browse/IGNITE-25129
> Project: Ignite
> Issue Type: Bug
> Reporter: Vladimir Steshin
> Priority: Major
> Labels: ise
>
> _TpchBenchmark_ with build at 31.03.2025, the query q5 and scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached H2 5 0.01 avgt 3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01 ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt 3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01 ss 1786.908
> ms/op
> {code}
> Workarounds:
> {code:java}
> /*+ ENFORCE_JOIN_ORDER */, /*+ NO_NL_JOIN +/
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
