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 10:53:04 GMT
Message-ID: <j21vb.252326$HS4.2286900@attbi_s01>

"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

Original text of this message

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