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