Hi! Can you measure the amount of time requirred to just open / connect?
Have you monitored the VM (memory / GC) usage and what about the cpu load? What's the size of one record returned in average? Can you execute this statement using plain JDBC just to get a feeling about what overhead of empire we are talking about? Personally I think 32k records is not that much.. CU Jens Von meinem iPhone gesendet > Am 12.06.2015 um 17:31 schrieb Nguyen, Chieu X <[email protected]>: > > Hi Rainer, > > > I have a SQL that returns 23K records, then, I called the code below to > return the data in a List. It consistently took around 1 – 2 minutes to > finish the getBeanList call. > > Is there a way in Empire-DB for me to speed up the performance? > > List<String> dataList = new LinkedList<String>(); > > DBReader reader = new DBReader(); > try > { > org.apache.commons.lang.time.StopWatch sw = new > org.apache.commons.lang.time.StopWatch(); > sw.start(); > > reader.open(dbCmd, dbConn); > dataList = reader.getBeanList(String.class); > > sw.stop(); > log.info("getDataFromTable: Getting data from table took " + > sw.toString() ); > } > catch (Exception e) > { > log.error("getDataFromTable: Error in running SQL " + > dbCmd.getSelect(), e); > } > finally > { > reader.close(); > } > > > Thank you, > > > Chieu Nguyen
