Skip site navigation (1) Skip section navigation (2)

Re: slow jdbc postgres connection

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Stefan Zweig <stefanzweig1881(at)web(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: slow jdbc postgres connection
Date: 2007-04-26 11:19:38
Message-ID: 46308ACA.4030505@opencloud.com (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2007-04-26 12:19:52
Subject: Re: slow jdbc postgres connection
Previous:From: Heikki LinnakangasDate: 2007-04-26 10:05:41
Subject: Re: slow jdbc postgres connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group