| From: | Heikki Linnakangas <heikki(at)enterprisedb(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 10:04:01 |
| Message-ID: | 46307911.7030201@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2007-04-26 10:05:41 | Re: slow jdbc postgres connection |
| Previous Message | Stefan Zweig | 2007-04-26 09:43:59 | Re: slow jdbc postgres connection |