On Wed, 10 May 2006, Thomas Vatter wrote:
Yes, the difference between psql command line and application is 6 seconds to 40 seconds. It is exactly the step resultSet = excecuteQuery() that needs 40 seconds. I use next() as a cursor through the resultSet, but I fear this is not enough, do I have to use createStatement(resultSetType, resultSetConcurrency) respectively prepareStatement (resultSetType, resultSetConcurrency) to achieve the cursor behaviour?
http://jdbc.postgresql.org/documentation/81/query.html#query-with-cursor Kris Jurka
