/[projects]/dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java
ViewVC logotype

Diff of /dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2330 by torben, Fri Feb 20 08:52:52 2015 UTC revision 2423 by torben, Tue Mar 3 08:30:02 2015 UTC
# Line 172  public class Database { Line 172  public class Database {
172                    
173                          // Forward only + concur_read_only + fetchsize tvinger driver til at hente en række af gangen (bedre performance ved store result sets)                          // Forward only + concur_read_only + fetchsize tvinger driver til at hente en række af gangen (bedre performance ved store result sets)
174                          // Se http://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html                          // Se http://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
                         //PreparedStatement stmt = conn.prepareStatement(sql);  
175                          PreparedStatement stmt = conn.prepareStatement(sql, java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);                          PreparedStatement stmt = conn.prepareStatement(sql, java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
176                          stmt.setFetchSize(Integer.MIN_VALUE);                          stmt.setFetchSize(Integer.MIN_VALUE);
177                    
# Line 217  public class Database { Line 216  public class Database {
216    
217                  saveStmt.addBatch();                  saveStmt.addBatch();
218                  batchCount++;                  batchCount++;
219                  if (batchCount >= 100) {                  if (batchCount >= 1000) {
220                          saveStmt.executeBatch();                          saveStmt.executeBatch();
221                          batchCount = 0;                          batchCount = 0;
222                  }                  }
Legend:
Removed from v.2330  
changed lines
  Added in v.2423
  ViewVC Help
Powered by ViewVC 1.1.20