请问xml中上万条insert执行要好几分钟，请问这个问题要怎么解决

Question

springboot集成liquibase的项目netbeans进行load database时

Answer 1

用批量插入的方式做，一条sql插入多行。
保证你的sql是：
INSERT INTO table ( "clo1", "col2", "col3", "col4", "col5" )
VALUES
( xxx,xxx,xxx,xxx,xxx),
( xxx,xxx,xxx,xxx,xxx),
( xxx,xxx,xxx,xxx,xxx);
而不是：
INSERT INTO table ( "clo1", "col2", "col3", "col4", "col5" ) VALUES ( xxx,xxx,xxx,xxx,xxx)；
INSERT INTO table ( "clo1", "col2", "col3", "col4", "col5" ) VALUES ( xxx,xxx,xxx,xxx,xxx)；
INSERT INTO table ( "clo1", "col2", "col3", "col4", "col5" ) VALUES ( xxx,xxx,xxx,xxx,xxx);