[IGNITE-19556] Sql. Implement cache for parsing sql requests.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: ignite-3 perfomance sql-performance
• Epic Link: AI3 Performance
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 24/May/23 09:24
• Updated: 29/May/23 10:59
• Resolved: 29/May/23 10:59

Description

starting point IgniteSqlParser#parse

In current implementation:

PreparedStatement insertPrepStmt ...
insertPrepStmt.addBatch();

will call sequential insertion row by row which leads to repeatedly parsing same

INSERT INTO ...

requests...

local benchmark with 1 server node shows 12% grow with cached requests.
TpchParseBenchmark ceases to be significant at all.

 

Issue Links

• is duplicated by: IGNITE-17765 Sql. Introduce cache for parsed statements