From: | Geert Bevin <gbevin(at)uwyn(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Resultset holdability |
Date: | 2005-10-21 15:46:37 |
Message-ID: | D38F6D5C-FEDE-4ABB-9D1B-B09BC9B451E9@uwyn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello,
I have a resultset that has many rows with bytea data.
It looks like me that when I iterate through the rows, the previous
rows are only garbage collectable when the resultset is closed, even
if I setup the statement like this:
statement.setFetchDirection(ResultSet.FETCH_FORWARD);
statement.setFetchSize(1);
Since it's bytea data, this fills up the memory very quickly. Any
thoughts on how to reduce this memory overhead and have the resultset
discard any previously fetched data?
Thanks for the help,
Geert
--
Geert Bevin Uwyn bvba
"Use what you need" Avenue de Scailmont 34
http://www.uwyn.com 7170 Manage, Belgium
gbevin[remove] at uwyn dot com Tel +32 64 84 80 03
PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Rogovskiy | 2005-10-21 15:57:08 | Speed up fixes |
Previous Message | Dave Cramer | 2005-10-20 22:28:40 | bug with pginterval |