[jira] [Resolved] (IGNITE-19556) Sql. Implement cache for parsing sql requests.

["Konstantin Orlov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-19556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Konstantin Orlov resolved IGNITE-19556.
---------------------------------------
    Resolution: Duplicate

> Sql. Implement cache for parsing sql requests.
> ----------------------------------------------
>
>                 Key: IGNITE-19556
>                 URL: https://issues.apache.org/jira/browse/IGNITE-19556
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 3.0.0-beta1
>            Reporter: Evgeny Stanilovsky
>            Priority: Major
>              Labels: calcite3-required, ignite-3, perfomance, sql-performance
>
> starting point IgniteSqlParser#parse
> In current implementation:
> {noformat}
> PreparedStatement insertPrepStmt ...
> insertPrepStmt.addBatch();
> {noformat}
> will call sequential insertion row by row which leads to repeatedly parsing same
> {noformat}
> INSERT INTO ...
> {noformat}
> requests...
> local benchmark with 1 server node shows 12% grow with cached requests.
> TpchParseBenchmark ceases to be significant at all.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)