Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: rs.next() is slow

Re: rs.next() is slow

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 20 Nov 2003 15:35:24 GMT
Message-ID: <0b5vb.58704$Dw6.323126@attbi_s02>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US