Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rs.next() is slow
"Jochen Wiedmann" <jochen.wiedmann_at_softwareag.com> wrote in message
news:3FBC9B61.1020200_at_softwareag.com...
> Jim Kennedy wrote:
>
> > Your fetch size is 10 rows.
>
> Quite obviously, but why does it take so much time to fetch the next 10
rows?
>
>
> Jochen
>
You are requesting 10 at a time, so it bundles up 10 and sends them to you.
Try a larger size like 100.
also you might try turning on Oracle trace to see if the sql that is being
sent is not what one would expect.
Jim
Received on Thu Nov 20 2003 - 04:53:04 CST