How to improve the speed

How can I solve the problem that the insertion of tens of thousands of data in the XML file results in the slow initialization of the database each time

springboot+liquibase

It seems reasonable that it’s going to slow things down if you are inserting tens of thousands of rows during each initialization of your database. Can you provide a little more context to your problem?

There are a large number of insert tags in XML, with tens of thousands of lines. How to optimize these statements to speed up the initialization of the database

One option would be to just use custom sql, instead of XML insert tags, since this will prevent the sql generation step for each of the insert statements:

<sql>
insert into XYZ values (...);
insert into XYZ values (...);
insert into XYZ values (...);
</sql>
1 Like

ok,thanks very much :grinning: