| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | jennie browne <jiebe(at)hotmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Prepared Statement Memory Size |
| Date: | 2006-07-18 17:06:24 |
| Message-ID: | Pine.BSO.4.63.0607181205001.11227@leary2.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Tue, 18 Jul 2006, jennie browne wrote:
> We have a prepared statement example below:
>
> With no dynamic parameters populated during runtime it will return
> roughly 1million rows. During execution of the query the
> preparedStatment grows in size up to 80MB and beyond.
>
> We have the fetchSize set to 1000
> And autocommit set to false.
>
> And the following params set
>
> stmt =
> conn.prepareStatement(query,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
>
setFetchSize will only work with ResultSet.TYPE_FORWARD_ONLY. It has no
effect on scrollable ResultSets.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2006-07-18 17:25:16 | Re: Prepared Statement Memory Size |
| Previous Message | jennie browne | 2006-07-18 16:42:35 | Prepared Statement Memory Size |