From: | Dianne Yumul <dianne(at)wellsgaming(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: No. of rows on result set |
Date: | 2005-07-15 16:37:00 |
Message-ID: | f146d61ff955f74f02aea434c5d33a1c@wellsgaming.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Jul 14, 2005, at 5:10 PM, Oliver Jowett wrote:
> If you need to use last(), then TYPE_SCROLL_INSENSITIVE is the way to
> go.
>
> Note that this means the driver will retrieve the entire resultset in
> one go rather than possibly using cursors (if you've set fetchsize and
> have autocommit off) -- you might have problems with big resultsets. If
> so I'd go with COUNT.
Ok, looking at the apps, the query either returns one row or a large
resultset. But using TYPE_SCROLL_INSENSITIVE should not be a problem
because fetchsize is not set and autocommit is not off.
Thank you so much for the great help.
Dianne
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Cryder | 2005-07-15 17:15:34 | Re: Timezone conversion woes |
Previous Message | Dave Cramer | 2005-07-15 13:05:06 | Re: Timezone conversion woes |