1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
Collection results = new ArrayList(8000);
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
try {
// Préparation de la requete
connection = ConnectionUtil.getConnection();
statement = connection.prepareStatement(REQUETE_SELECT, ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
if (manu)
statement.setString(1, "1");
else
statement.setString(1, "0");
rs = statement.executeQuery();
long avant = System.currentTimeMillis();
logger.info("Avant:" + avant);
//[GEI] Optimisation test
//rs.setFetchSize(1000);
//rs.last();
//rs.beforeFirst();
// [/GEI] Fin de l'optimisation test
// Boucle sur les resultats
while (rs.next()) {
TempSprintDTO dto = new TempSprintDTO();
dto.setId(rs.getInt(1));
dto.setLigne(rs.getString(2));
dto.setManu(manu);
results.add(dto);
}
long apres = System.currentTimeMillis();
logger.info("Apres:" + apres);
logger.info("Difference:" + (apres - avant));
}
catch (SQLException e) {
throw e;
}
finally {
if (rs != null)
rs.close();
if (statement != null)
statement.close();
if (connection != null)
connection.close();
}
return results; |
Partager