Very Computer

by **Lijia** » Thu, 27 Jun 2002 04:47:22

Hi,

I'm trying to select 100k records from Oracle 9i via OCI. I used
prefetch method, but it's way too slow. Can I use array fetch to
improve the performance? Does anyone know where I can find some sample
code?

Thanks a lot,

Lijia

by **Sybrand Bakke** » Thu, 27 Jun 2002 08:26:24

Quote:>Hi,

>I'm trying to select 100k records from Oracle 9i via OCI. I used
>prefetch method, but it's way too slow. Can I use array fetch to
>improve the performance? Does anyone know where I can find some sample
>code?

>Thanks a lot,

>Lijia

In the OCI documentation?

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

by **Lijia** » Thu, 27 Jun 2002 22:45:27

> >Hi,

> >I'm trying to select 100k records from Oracle 9i via OCI. I used
> >prefetch method, but it's way too slow. Can I use array fetch to
> >improve the performance? Does anyone know where I can find some sample
> >code?

> >Thanks a lot,

> >Lijia

> In the OCI documentation?

> Regards

> Sybrand Bakker, Senior Oracle DBA

> To reply remove -verwijderdit from my e-mail address

In the documentation, it does not give any sample for array fetch, I'm not sure
how to establish array fetching of a table with 8 fields, that's why I hope I
can find some sample code as reference.

Thanks,

Lijia

Very Computer

OCI Array Fetch Sample Code.

OCI Array Fetch Sample Code.

OCI Array Fetch Sample Code.

OCI Array Fetch Sample Code.