--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java 2015/02/13 15:45:24 2283 +++ dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java 2015/02/15 10:11:13 2296 @@ -21,14 +21,15 @@ String sql = "SELECT id,vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,upper(distributor) AS distributor,dbkbane,koreliste,rute " + "FROM fulddaekning.adressetabel " - //+ "WHERE postnr >=2000" //DEBUG only + + "WHERE gadeid IS NOT NULL " + //+ "AND postnr = 8700" //DEBUG only ; Connection conn = DBConnection.getConnection(); Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); ResultSet res = stmt.executeQuery(sql); - List
list = new ArrayList(); + List list = new ArrayList(2600000);//initial capacity 2.6 mio while (res.next()) { Address a = new Address(); @@ -65,6 +66,10 @@ } public static List