On Wed, 2006-05-10 at 15:54, 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?
Not sure. I don't use a lot of prepared statements. I tend to build
queries and throw the at the database. In that instance, it's done
like:
create cursor cursorname as select (rest of query here);
fetch from cursorname;
You can find more on cursors here:
http://www.postgresql.org/docs/8.1/interactive/sql-declare.html
Not sure if you can use them with prepared statements, or if prepared
statements have their own kind of implementation.