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:3FBCA55D.60202_at_softwareag.com...
> 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
>
Gosh, hard to have known that. If you both have the same code also them
maybe there is something wrong with your network card or setting. Are your
session parameters the same (eg optimizer is same not one all_rows and
first_rows)
Jim
Received on Thu Nov 20 2003 - 09:35:24 CST