--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2015/02/20 08:52:52 2330 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2015/03/03 08:30:02 2423 @@ -172,7 +172,6 @@ // Forward only + concur_read_only + fetchsize tvinger driver til at hente en række af gangen (bedre performance ved store result sets) // Se http://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html - //PreparedStatement stmt = conn.prepareStatement(sql); PreparedStatement stmt = conn.prepareStatement(sql, java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); stmt.setFetchSize(Integer.MIN_VALUE); @@ -217,7 +216,7 @@ saveStmt.addBatch(); batchCount++; - if (batchCount >= 100) { + if (batchCount >= 1000) { saveStmt.executeBatch(); batchCount = 0; }