Konstantin Orlov created IGNITE-17765:
-----------------------------------------

             Summary: Sql. Introduce cache for parsed statements
                 Key: IGNITE-17765
                 URL: https://issues.apache.org/jira/browse/IGNITE-17765
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Konstantin Orlov


Parsing of a SQL statement is fairly expensive operation. We could reduce query 
processing time by introducing a cache of statement text to parsed syntax tree.

Suggested solution is as follow: when query text is passed to a query 
processor, it should be parsed first, then we need to check if such statement 
is already in a statements cache. If it is not, then statementId (type of long, 
locally unique) should be assigned to the statement and pair <statementId, 
parsed tree> should be passed next to the query optimizer. Query optimizer, in 
turn, check if the query with given statementId is alredy optimized. 



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

Reply via email to