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

Re: slow jdbc postgres connection

From: Stefan Zweig <stefanzweig1881(at)web(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: slow jdbc postgres connection
Date: 2007-04-26 09:43:59
Message-ID: 58987573@web.de (view raw or flat)
Thread:
Lists: pgsql-jdbc
hi,

just to be sure that it cannot be the intranet-connection i tried to run my java test database application directly on the server. mysql-jdbc answered within 20ms pgsql-jdbc needed 5494ms and i have no idea why?

any advices would be appreciated.

regards. stefan
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192


Responses

pgsql-jdbc by date

Next:From: Heikki LinnakangasDate: 2007-04-26 10:04:01
Subject: Re: slow jdbc postgres connection
Previous:From: Stefan ZweigDate: 2007-04-26 09:19:30
Subject: slow jdbc postgres connection

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