--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/09/12 15:23:06 2218 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/09/12 21:03:06 2219 @@ -14,9 +14,11 @@ import java.util.logging.Logger; + public class Database { Logger logger = Logger.getLogger(Database.class.getName()); + int batchCount = 0; Connection conn; PreparedStatement saveStmt; @@ -177,12 +179,21 @@ saveStmt.setDouble(19, bedsteAfstand); - saveStmt.executeUpdate(); - saveStmt.clearParameters(); - + saveStmt.addBatch(); + batchCount++; + if (batchCount >= 100) { + saveStmt.executeBatch(); + batchCount = 0; + } + //saveStmt.executeUpdate(); + //saveStmt.clearParameters(); //saveStmt.close(); - + } + + public synchronized void saveBatch() throws SQLException{ + saveStmt.executeBatch(); + batchCount = 0; } @@ -231,6 +242,8 @@ connectionProps.put("user", db_user); connectionProps.put("password", db_pass); + + conn = DriverManager.getConnection( "jdbc:mysql://" + db_host +