mysql 5.6批处理慢_java – JDBC批处理执行速度极慢

任何人都可以告诉我我做错了什么我在

mysql中执行350个插件并且它需要40秒.

这是代码

long t0 = System.currentTimeMillis();

Connection con = connectionProvider.getConnection();

PreparedStatement s = con.prepareStatement("insert into domkee.friends(idFriends,friend1Id,friend2Id,friend2Name) values(?,?,?)");

con.setAutoCommit(false);

for (Friend f : friends) {

s.setLong(1,0);

s.setLong(2,f.getFriend1Id());

s.setLong(3,f.getFriend2Id());

s.setString(4,f.getFriend2Name());

s.addBatch();

}

long t1 = System.currentTimeMillis() - t0;

s.executeBatch();

long t2 = System.currentTimeMillis()-t0;

con.commit();

long t3 = System.currentTimeMillis()-t0;

s.close();

con.close();

long t4 = System.currentTimeMillis()-t0;

System.out.println(((double)t1/1000) + ";" + ((double)t2/1000) + ";" + ((double)t3/1000) + ";" + ((double)t4/1000));

这是控制台：

0.156;39.251;39.376;39.486

所以.executeBatch()花了40秒,可能是什么问题？