如何提高批量插入效率？

1、将连接参数rewriteBatchedStatements设为true

Connection c = DriverManager.getConnection("jdbc:mysql://host:3306/db?useServerPrepStmts=false&rewriteBatchedStatements=true", "username", "password");

2、原生SQL批量插入

START TRANSACTION

INSERT INTO `table_name` VALUES (data1), (data2), ..., (data1000);

COMMIT

3、如果是Mybatis里，要将ExcutorType设为BATCH批量模式

4、

https://stackoverflow.com/questions/11389449/performance-of-mysql-insert-statements-in-java-batch-mode-prepared-statements-v

如何提高批量插入效率？

原文：https://www.cnblogs.com/huigee/p/9783513.html