Pavel Pereslegin created IGNITE-27323:
-----------------------------------------
Summary: Improve UX of huge schema creation
Key: IGNITE-27323
URL: https://issues.apache.org/jira/browse/IGNITE-27323
Project: Ignite
Issue Type: Improvement
Components: sql ai3
Affects Versions: 3.1
Reporter: Pavel Pereslegin
Assignee: Pavel Pereslegin
As per schema sync design, every DDL operation creates new version of the
schema in the nearest future, which by default is 1 second apart from moment of
execution. This renders the execution time of every DDL statements as at least
1 second (again, by default). The situation becomes even worse with indexes, as
they require up to 3 catalog operations. In certain scenarios, like creation of
500 tables and 1500 indexes sequentially (e.g. statement by statement), the
whole time may easily exceed 1 hour duration.
We should improve the UX in such a scenario. Things to consider:
* Improve documentation to reflect this behavior. Add nodes how this could be
improved (use of batching).
* Detect such cases in client handler (single node) and print suggestion to the
SERVER log
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
