[
https://issues.apache.org/jira/browse/IGNITE-24134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-24134:
--------------------------------------
Fix Version/s: 3.0
> Sql. Improve performance of KV plan in SQL
> ------------------------------------------
>
> Key: IGNITE-24134
> URL: https://issues.apache.org/jira/browse/IGNITE-24134
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Currently, the difference in latency between pure KV and SQL in YCSB-get
> scenario via embedded client is almost 2x:
> {code}
> Benchmark (clusterSize) (fsync) Mode Cnt Score Error
> Units
> SelectBenchmark.kvGet 1 false avgt 20 3.238 ± 0.185
> us/op
> SelectBenchmark.sqlGet 1 false avgt 20 5.889 ± 0.143
> us/op
> {code}
> This can be improved by caching expressions in Executable plan instead of
> looking up they every time in expressions cache.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
