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: Jochen Wiedmann <jochen.wiedmann_at_softwareag.com>
Date: Thu, 20 Nov 2003 12:28:29 +0100
Message-ID: <3FBCA55D.60202@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 Received on Thu Nov 20 2003 - 05:28:29 CST

Original text of this message

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