--- dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java 2015/11/02 12:18:03 2763 +++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java 2015/11/03 10:02:56 2764 @@ -17,6 +17,7 @@ import dk.daoas.daoadresseservice.beans.HundredePctBean; import dk.daoas.daoadresseservice.beans.SearchResult; import dk.daoas.daoadresseservice.util.DeduplicateHelper; +import dk.daoas.daoadresseservice.util.TimingHelper; public class DatabaseLayerImplementation implements DatabaseLayer { @@ -24,6 +25,8 @@ @Override public List
getAllAdresses() throws SQLException { + TimingHelper timing = new TimingHelper(); + String debugFilter = DatabaseLayerImplementation.DEBUG ? " AND postnr = 8700 " : ""; String sql = @@ -82,7 +85,7 @@ } res.close(); - System.out.println("Loaded " + list.size() + " adresses"); + System.out.println("DB Loaded " + list.size() + " adresses in " + timing.getElapsed() + "ms"); return list; } @@ -90,6 +93,7 @@ @Override public List getAliasList() throws SQLException { + TimingHelper timing = new TimingHelper(); String sql = "SELECT postnr,vejnavn,aliasvejnavn " + @@ -119,7 +123,7 @@ res.close(); - System.out.println("Loaded " + list.size() + " aliase beans"); + System.out.println("DB Loaded " + list.size() + " aliase beans in " + timing.getElapsed() + "ms"); return list; } @@ -128,6 +132,9 @@ @Override public List getExtendedAdresslist() throws SQLException { + + TimingHelper timing = new TimingHelper(); + String debugFilter1 = DatabaseLayerImplementation.DEBUG ? " WHERE orgPostnr = 8700 " : ""; String debugFilter2 = DatabaseLayerImplementation.DEBUG ? " AND orgPostnr = 8700 " : ""; @@ -172,7 +179,7 @@ res.close(); - System.out.println("Loaded " + list.size() + " extendedbeans"); + System.out.println("DB Loaded " + list.size() + " extendedbeans in " + timing.getElapsed() + "ms"); return list; } @@ -180,6 +187,8 @@ @Override public Map get100PctList() throws SQLException { + TimingHelper timing = new TimingHelper(); + String sql = "SELECT postnr,UPPER(distributor) as distributor,rute,koreliste,dbkbane " + "FROM bogleveringer.adresser_udenfor_daekning"; @@ -209,7 +218,7 @@ res.close(); - System.out.println("Loaded " + map.size() + " 100pct beans"); + System.out.println("DB Loaded " + map.size() + " 100pct beans in " + timing.getElapsed() + "ms"); return map; }