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.