/[projects]/dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
ViewVC logotype

Diff of /dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java

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

revision 2284 by torben, Fri Feb 13 15:45:24 2015 UTC revision 2285 by torben, Fri Feb 13 15:58:36 2015 UTC
# Line 28  public class DatabaseLayer { Line 28  public class DatabaseLayer {
28                  Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);                  Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
29                  ResultSet res = stmt.executeQuery(sql);                  ResultSet res = stmt.executeQuery(sql);
30                                    
31                  List<Address> list = new ArrayList<Address>();                  List<Address> list = new ArrayList<Address>(2600000);//initial capacity 2.6 mio
32                                    
33                  while (res.next()) {                  while (res.next()) {
34                          Address a = new Address();                          Address a = new Address();
# Line 82  public class DatabaseLayer { Line 82  public class DatabaseLayer {
82                  Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);                  Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
83                  ResultSet res = stmt.executeQuery(sql);                  ResultSet res = stmt.executeQuery(sql);
84                                    
85                  List<ExtendedBean> list = new ArrayList<ExtendedBean>();                  List<ExtendedBean> list = new ArrayList<ExtendedBean>( 350000); //Initial capacity 350K
86                  while (res.next()) {                  while (res.next()) {
87                          ExtendedBean eb = new ExtendedBean();                          ExtendedBean eb = new ExtendedBean();
88                          eb.orgId = res.getInt(1);                          eb.orgId = res.getInt(1);
# Line 128  public class DatabaseLayer { Line 128  public class DatabaseLayer {
128                  stmt.close();                  stmt.close();
129                  conn.close();                  conn.close();
130                                    
131                  System.out.println("Loaded " + map.size() + " extendedbeans");                  System.out.println("Loaded " + map.size() + " 100pct beans");
132                                    
133                  return map;                  return map;
134                                    
Legend:
Removed from v.2284  
changed lines
  Added in v.2285
  ViewVC Help
Powered by ViewVC 1.1.20