OCI bulk select.

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 Mon Jun 24 2002 - 14:46:16 CDT