Re: slow jdbc postgres connection

Stefan Zweig wrote:
> when i execute the following query via pgAdminIII i get a result within 31ms
>
> Select version()
> result: PostgreSQL 8.1
>
> if try to execute the same query using the jdbc-interface from a java-application the same query needs horrible
4756ms.
> my jdbc driver is  8.1-409 JDBC 3
> my postgres version is 8.1.8
> my JRE-Version: 1.5.0_07

Strange. Are you sure the time is spent on executing the query, and not
on acquiring the connection? What kind of an application is it? There's
no application server or framework involved? Would you please add
loglevel=1 to the URL, and post the output? Maybe that will give a clue.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com