任何人都可以告诉我我做错了什么我在
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秒,可能是什么问题？
