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: OCI bulk select.

Re: OCI bulk select.

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 25 Jun 2002 05:15:04 GMT
Message-ID: <s%SR8.312411$cQ3.17265@sccrnsc01>


That means it must fetch 5,000 rows at a time. This could take awhile. Try 100 rows instead.
Jim
"Lijia Xu" <xu98248_at_hotmail.com> wrote in message news:aa544eb1.0206241146.49a8a35d_at_posting.google.com...
> Hi, All,
>
> I'm trying to select a large amount of records via OCI in Oracle 9i,
> in the scale of 100k. I use prefetch mehod, prefetch 5k at one time,
> then OCIStmtFetch to fetch next, but it's very slow. Does anybody have
> any idea how to improve this?
>
> Thanks a lot,
>
> Lijia
Received on Tue Jun 25 2002 - 00:15:04 CDT

Original text of this message

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