Re: slow jdbc postgres connection - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: slow jdbc postgres connection
Date
Msg-id 46308ACA.4030505@opencloud.com
Whole thread Raw
In response to slow jdbc postgres connection  (Stefan Zweig <stefanzweig1881@web.de>)
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: slow jdbc postgres connection
Next
From: Oliver Jowett
Date:
Subject: Re: slow jdbc postgres connection