FetchSize and Cursor
Posted: Thu 26 May 2005 17:33
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
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