[
https://issues.apache.org/jira/browse/IGNITE-22501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov reassigned IGNITE-22501:
-----------------------------------------
Assignee: Konstantin Orlov
> Sql. Batching DDL statement for scripts
> ---------------------------------------
>
> Key: IGNITE-22501
> URL: https://issues.apache.org/jira/browse/IGNITE-22501
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Iurii Gerzhedovich
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> From an architectural perspective, AI3 has many waits for any DDL statements
> due to need to have strong guarantees. It leads to a significant time of
> execution initialization script of a database containing tens or tons of DDL
> ( CREATE TABLE, CREATE INDEX ...) statements.
> To improve the performance of such scripts, you can form batches of
> continuous sequences of DDL operations and execute them as a single catalog
> command.
> In case of any error during apply such batches it should be fallbacks to
> statement by statement execution to provide user exact statement with occured
> error.
> Batching will be implemented only for scripts (i.e. only
> org.apache.ignite.sql.IgniteSql#executeScript(java.lang.String,
> java.lang.Object...) and java.sql.Statement#execute(java.lang.String) API
> calls). Consequent calls will be executed as separate batches.
> The only requirement is that batching must be transparent to the user, no
> changes in observable behavior must be made.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
