Jack Orenstein wrote:
> If I'm reading the source code correctly, the PostgreSQL 7.3.4 JDBC
> driver creates a ResultSet by evaluating the entire query, and putting
> all the rows into a Vector. ResultSet.next() iterates over the
> Vector. Is that in fact what is happening?
That's probably true for the 7.3.4 driver, which is quite old now.
The latest 7.4 drivers (which will work against a 7.3 server) will use a
cursor to fetch the resultset incrementally when:
- the statement fetchsize is non-zero; and
- autocommit is off (and
- the statement is TYPE_FORWARD_ONLY; and
- the query is a single SELECT
There's also been a patch posted recently (check the archives) that
allows use of cursors with scrollable resultsets.
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2004-05-20 16:01:09|
|Subject: Re: Queries with large ResultSets|
|Previous:||From: Jack Orenstein||Date: 2004-05-19 21:29:00|
|Subject: Queries with large ResultSets|