Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rs.next() is slow
Jim Kennedy wrote:
> 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.
I'm uncertain whether I understand you: My colleague has the *same* fetch size of 10 rows and he doesn't have any issues. So why should the fetch have influence on my machine/application?
Regards,
Jochen Received on Thu Nov 20 2003 - 05:28:29 CST
![]() |
![]() |