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