Hi,
I have two questions.
1. Is it possible to enable prefetching of any sort using OraDirect?
2. I am primarily using Ref Cursors to return data, however my understanding is that this is a server side cursor and therefore can only fetch one result at a time. If this is true, does the FetchSize property have any affect at all? I've done a few experiments and as far as I can tell the FetchSize property seems to have no impact on any of my database read operations.
Tks,
Ben
FetchSize and Cursor
1. Prefetch works with OCI connection starting from Oracle client 9i, with SELECT queries. It does not work with cursor parameters. The number of prefetched rows is OracleCommand.FetchSize. If OracleCommand.FetchSize is set then OCI loads these rows to client side after executing statement.
2. Rows are fetched by blocks at one time when you call OracleDataReader.Read consequently. The number of rows in block is OracleCommand.FetchSize. This works with SELECT statements and cursor parameters
2. Rows are fetched by blocks at one time when you call OracleDataReader.Read consequently. The number of rows in block is OracleCommand.FetchSize. This works with SELECT statements and cursor parameters