Actually, at the moment the driver gets all the result set at once, so
no setFetchSize() isn't implemented.
However you can get a cursor back and scroll through the result set
yourself
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Marin Dimitrov
Sent: Thursday, March 14, 2002 6:55 AM
To: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] [GENERAL] JDBC-Question
>
> Do I have all the data (1000 rows) in memory or dose the driver fetch
> the data as needed (while iterating over the rset instance) from my
> postgresql backend.
>
since I would expect that the driver retrieves the result sets in chunks
I'd like to know if this behaviour can be controlled - i.e. is
setFetchSize() implemented?
thanx,
Marin
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster