Stefan Zweig wrote:
long start=System.currentTimeMillis();//start time measurement pgresultSet = pgstatement.executeQuery(pgquery); long time=System.currentTimeMillis()-start;//end time measurement //time =4756ms
And if you run the query a second time on the same connection (or even on a completely new connection in the same JVM), what's the time for that? I'd guess you're measuring mostly classloading costs.
-O