You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ignite.apache.org by "AMashenkov (via GitHub)" <gi...@apache.org> on 2025/04/02 18:17:02 UTC
Re: [PR] IGNITE-24976 Sql. Optimize sql row serialization [ignite-3]
AMashenkov commented on PR #5536:
URL: https://github.com/apache/ignite-3/pull/5536#issuecomment-2773355653
I've added a UpgradeRowBenchmark that runs simple select with and without projection.
```
Master (no row upgrading)
Benchmark (clusterSize) (fsync) Mode Cnt Score Error Units
UpgradeRowBenchmark.selectAll 1 false avgt 20 100.949 ± 0.178 ms/op
UpgradeRowBenchmark.selectAllProjected 1 false avgt 20 137.263 ± 0.319 ms/op
My branch (no row upgrading)
Benchmark (clusterSize) (fsync) Mode Cnt Score Error Units
UpgradeRowBenchmark.selectAll 1 false avgt 20 102.289 ± 0.144 ms/op
UpgradeRowBenchmark.selectAllProjected 1 false avgt 20 131.582 ± 0.136 ms/op
```
The same benchmark, but i've added a column after populating the table.
```
Master (with row upgrading)
Benchmark (clusterSize) (fsync) Mode Cnt Score Error Units
UpgradeRowBenchmark.selectAll 1 false avgt 20 294.983 ± 0.785 ms/op <--- this looks unexpected
UpgradeRowBenchmark.selectAllProjected 1 false avgt 20 189.532 ± 0.213 ms/op
My branch (with row upgrading)
Benchmark (clusterSize) (fsync) Mode Cnt Score Error Units
UpgradeRowBenchmark.selectAll 1 false avgt 20 199.317 ± 0.403 ms/op
UpgradeRowBenchmark.selectAllProjected 1 false avgt 20 177.769 ± 0.274 ms/op
```
--
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: notifications-unsubscribe@ignite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org