sqlserver 批量插入数据的速度和驱动相关
今天对sqlserver的批量插入进行了一下简单的测试
发现用 msbase.jar mssqlserver.jar msutil.jar 这3个包做驱动的时候，批量插入(5000一批，分多批)和一条条的插入速度上没有明显差异，插入37万条数据居然要12分钟的时间,当换用sourceforge上的jtds.jar这个驱动后，速度有了飞速的提高，同样是37万条数据,居然只要一分钟.微软官方的驱动也太随意了吧，怎么连jdbc的标准都不好好实现,晕!
public void insert2DicIPLoc(List list){ Connection conn = null;PreparedStatement pstmt = null;try { connn = DBUtil.getConnection(); pstmt = conn.prepareStatement(INSERT_SQL); IpLocation ipLocation = null; long start = System.currentTimeMillis(); for(int i = 0; i < list.size(); i++){ ipLocation = (IpLocation)list.get(i); pstmt.setLong(1, ipToLong(ipLocation.getIpFr()));pstmt.setLong(2, ipToLong(ipLocation.getIpTo()));pstmt.setString(3, ipLocation.getLoca1());pstmt.setString(4, ipLocation.getLocal2());pstmt.addBatch(); } long end = System.currentTimeMillis(); System.out.println("addBatch耗时:"+(end - start)+"ms");pstmt.executeBatch();conn.commit();long end2 = System.currentTimeMillis();System.out.println("executeBatch耗时:"+(end2 - end)+"ms");} catch (SQLException e) {e.printStackTrace();}finally{DBUtil.close(this, conn); DBUtil.close(this,pstms);}}