[jira] [Created] (IGNITE-24134) Sql. Improve performance of KV plan in SQL

[Konstantin Orlov (Jira)]

Konstantin Orlov created IGNITE-24134:
-----------------------------------------

             Summary: 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


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)