Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OCI bulk select.
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
![]() |
![]() |