Skip to Main Content
Forums

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!

performance issue with ODP.NET DataReader

864049May 24 2011 — edited Oct 8 2013
Either I am doing something wrong or the performance is really bad. I tried to play with FetchSize property by increasing it to 1M, 4M and even 8M but that did not help. I test MS SQL 2008 and Oracle 11g R2 with identical data content. When using ADO/OLEDB DataSet I am getting similar performance for both dbms. When working with ADO.NET and DataReader from ODP.NET, the performance of reading data is 20-25 times worse. I just hope we are missing something in our code (a switch, parameter etc). I found somebody has has already touched this topic but there was no conclusion. Can anyone please help ? Any hint will be greatly appreciated. Thank you.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 5 2013
Added on May 24 2011
#odp-net, #performance
7 comments
1,380 views