From: | Stefan Zweig <stefanzweig1881(at)web(dot)de> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | slow jdbc postgres connection |
Date: | 2007-04-26 09:19:30 |
Message-ID: | 58958572@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
hi i have the following problem:
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
Connection pgconnection = null;
// Load the pgSQL JDBC driver
String pgdriverName = "org.postgresql.Driver";
Class.forName(pgdriverName);
// Create a connection to the "test" database
String pgserverName = "10.100.6.245";
String pgdatabase = "test";
String url = "jdbc:postgresql://" + pgserverName + "/" + pgdatabase + "?characterEncoding=UTF8&useUnicode=true";
String username = "user";
String password = "password";
pgconnection = DriverManager.getConnection(url, username, password);
ResultSet pgresultSet;
Statement pgstatement;
pgstatement = pgconnection.createStatement();
String pgquery;
pgquery="SELECT version()";
long start=System.currentTimeMillis();//start time measurement
pgresultSet = pgstatement.executeQuery(pgquery);
long time=System.currentTimeMillis()-start;//end time measurement
//time =4756ms
pgconnection.close();
if i do the similar query on our mysql database, which is on the same local server, i get quick results, so the reason probably cannot be a slow intranet-connection
any help would be appriciated.
regards. stefan
_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Zweig | 2007-04-26 09:43:59 | Re: slow jdbc postgres connection |
Previous Message | Kris Jurka | 2007-04-25 19:37:58 | Re: Question for the XAConnections default autocommit state |