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
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>
ok,thanks very much