Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODP.Net Fetch size

4008784Jul 17 2020 — edited Jul 17 2020

Hi All,

Just want to know if giving Fetch size in the below code will improve performance if we know the number of records to be fetched ahead.

The below code calls Oracle stored procedure which returns cursor as a output result.

DataTable dt;

.......

cmd.ExecuteNonQuery();

OracleDataReader dr = ((OracleRefCursor)cmd.Parameters["output"].Value).GetDataReader();

dt.Load(dr);

return dt;

Since we are not looping data reader and loading directly to the DataTable, will the data be fetched all at once or it will fetch with default fetch size.

This post has been answered by Alex Keh-Oracle on Jul 17 2020
Jump to Answer

Comments

Processing

Post Details

Added on Jul 17 2020
1 comment
206 views