slow jdbc postgres connection
От | Stefan Zweig |
---|---|
Тема | slow jdbc postgres connection |
Дата | |
Msg-id | 58958572@web.de обсуждение исходный текст |
Ответы |
Re: slow jdbc postgres connection
Re: slow jdbc postgres connection Re: slow jdbc postgres connection |
Список | 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 probablycannot 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
В списке pgsql-jdbc по дате отправления: