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 |
|
|
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 |
} |
} |