zstan opened a new pull request, #3608:
URL: https://github.com/apache/ignite-3/pull/3608
**Benchmark (clusterSize) (fsync) Mode Cnt
Score Error Units**
```
SqlJoinBenchmark.leftHashJoin 1 false avgt 10
320648.648 ± 19851.614 us/op
SqlJoinBenchmark.leftHashJoin 2 false avgt 10
334971.021 ± 7666.809 us/op
SqlJoinBenchmark.leftMergeJoin 1 false avgt 10
500358.861 ± 10694.029 us/op
SqlJoinBenchmark.leftMergeJoin 2 false avgt 10
533416.228 ± 20695.084 us/op
SqlJoinBenchmark.leftNestedJoin 1 false avgt 10
647271.776 ± 17448.071 us/op
SqlJoinBenchmark.leftNestedJoin 2 false avgt 10
665951.450 ± 17752.174 us/op
```
---
**Costs for equal tables and join conditions:**
```
Project(ID=[$0]): rowcount = 11500.0, cumulative cost = IgniteCost
[rowCount=153603.40371976182, cpu=153603.40371976182, memory=320000.0, io=0.0,
network=120000.0], id = 465
HashJoin(condition=[=($1, $2)], joinType=[left], variablesSet=[[]]):
rowcount = 11500.0, cumulative cost = IgniteCost [rowCount=142103.40371976182,
cpu=142103.40371976182, memory=320000.0, io=0.0, network=120000.0], id = 464
Exchange(distribution=[single]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=20000.0, cpu=20000.0, memory=0.0, io=0.0,
network=80000.0], id = 461
TableScan(table=[[PUBLIC, TEST_TX]], tableId=[7], requiredColumns=[{0,
1}]): rowcount = 10000.0, cumulative cost = IgniteCost [rowCount=10000.0,
cpu=10000.0, memory=0.0, io=0.0, network=0.0], id = 460
Exchange(distribution=[single]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=20000.0, cpu=20000.0, memory=0.0, io=0.0,
network=40000.0], id = 463
TableScan(table=[[PUBLIC, TEST_TX]], tableId=[7],
requiredColumns=[{1}]): rowcount = 10000.0, cumulative cost = IgniteCost
[rowCount=10000.0, cpu=10000.0, memory=0.0, i
```
```
Project(ID=[$0]): rowcount = 11500.0, cumulative cost = IgniteCost
[rowCount=1.000515E8, cpu=4.000515E8, memory=40000.0, io=0.0,
network=120000.0], id = 292
NestedLoopJoin(condition=[=($1, $2)], joinType=[left], variablesSet=[[]]):
rowcount = 11500.0, cumulative cost = IgniteCost [rowCount=1.0004E8,
cpu=4.0004E8, memory=40000.0, io=0.0, network=120000.0], id = 291
Exchange(distribution=[single]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=20000.0, cpu=20000.0, memory=0.0, io=0.0,
network=80000.0], id = 288
TableScan(table=[[PUBLIC, TEST_TX]], tableId=[7], requiredColumns=[{0,
1}]): rowcount = 10000.0, cumulative cost = IgniteCost [rowCount=10000.0,
cpu=10000.0, memory=0.0, io=0.0, network=0.0], id = 287
Exchange(distribution=[single]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=20000.0, cpu=20000.0, memory=0.0, io=0.0,
network=40000.0], id = 290
TableScan(table=[[PUBLIC, TEST_TX]], tableId=[7],
requiredColumns=[{1}]): rowcount = 10000.0, cumulative cost = IgniteCost
[rowCount=10000.0, cpu=10000.0, memory=0.0, i
```
```
Project(ID=[$0]): rowcount = 11500.0, cumulative cost = IgniteCost
[rowCount=91500.0, cpu=704120.422318571, memory=120000.0, io=0.0,
network=120000.0], id = 470
MergeJoin(condition=[=($1, $2)], joinType=[left], variablesSet=[[]],
leftCollation=[[1]], rightCollation=[[0]]): rowcount = 11500.0, cumulative cost
= IgniteCost [rowCount=80000.0, cpu=692620.422318571, memory=120000.0, io=0.0,
network=120000.0], id = 469
Exchange(distribution=[single]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=30000.0, cpu=306310.2111592855, memory=80000.0, io=0.0,
network=80000.0], id = 465
Sort(sort0=[$1], dir0=[ASC]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=20000.0, cpu=296310.2111592855, memory=80000.0, io=0.0,
network=0.0], id = 464
TableScan(table=[[PUBLIC, TEST_TX]], tableId=[7],
requiredColumns=[{0, 1}]): rowcount = 10000.0, cumulative cost = IgniteCost
[rowCount=10000.0, cpu=10000.0, memory=0.0, io=0.0, network=0.0], id = 463
Exchange(distribution=[single]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=30000.0, cpu=306310.2111592855, memory=40000.0, io=0.0,
network=40000.0], id = 468
Sort(sort0=[$0], dir0=[ASC]): rowcount = 10000.0, cumulative cost =
IgniteCost [rowCount=20000.0, cpu=296310.2111592855, memory=40000.0, io=0.0,
network=0.0], id = 467
TableScan(table=[[PUBLIC, TEST_TX]], tableId=[7],
requiredColumns=[{1}]): rowcount = 10000.0, cumulative cost = IgniteCost
[rowCount=10000.0, cpu=10000.0, memory=0.0,
```
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
