[
https://issues.apache.org/jira/browse/IGNITE-20763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17781347#comment-17781347
]
Konstantin Orlov commented on IGNITE-20763:
-------------------------------------------
Results before patch
|| Benchmark || (fsync) || Mode || Cnt || Score || Error || Units ||
| SqlOneNodeBenchmark.selectAllFromSystemRange | false | avgt | 20 | 110.279 |
± 3.912 | us/op |
| InsertBenchmark.sqlInsert | false | avgt | 20 | 0.957 | ± 0.060 | ms/op |
| SelectBenchmark.sqlGet | false | avgt | 20 | 791.166 | ± 37.719 | us/op |
Results after patch
|| Benchmark || (fsync) || Mode || Cnt || Score || Error || Units ||
| SqlOneNodeBenchmark.selectAllFromSystemRange | false | avgt | 20 | 81.783 | ±
3.446 | us/op |
| InsertBenchmark.sqlInsert | false | avgt | 20 | 0.912 | ± 0.024 | ms/op |
| SelectBenchmark.sqlGet | false | avgt | 20 | 738.099 | ± 24.126 | us/op |
> Sql. Clean up query execution
> -----------------------------
>
> Key: IGNITE-20763
> URL: https://issues.apache.org/jira/browse/IGNITE-20763
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
> Attachments: flamegraph.html
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> According to flamegraph, QueryTaskExecutor spent more time doing unnecessary
> staff (like instantiating VoidLogger or filling stack traces on happy path
> execution flow) rather than on query itself in case of primitive queries like
> {{SELECT * FROM TABLE(system_range(0, 1))}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
