[
https://issues.apache.org/jira/browse/IGNITE-17765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Mashenkov reassigned IGNITE-17765:
-----------------------------------------
Assignee: Andrey Mashenkov (was: Pavel Pereslegin)
> 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
> Assignee: Andrey Mashenkov
> Priority: Major
> Labels: ignite-3, sql-performance, tech-debt
> Fix For: 3.0.0-beta2
>
> Time Spent: 4h 10m
> Remaining Estimate: 0h
>
> 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)
