You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2023/05/24 09:25:00 UTC

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

Evgeny Stanilovsky created IGNITE-19556:
-------------------------------------------

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


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)