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!

DataReader vs DataAdapter Performance Comparison with ODP.NET

659056Jan 26 2010
hi,
we're comparing performances of OracleDataReader and OracleDataAdapter,
to retrieve rows from a table (we tried 1000, 10000, 100000 rows)
(we're both using an ad-hoc stored procedure or a simple direct Select statement)

Both performances are roughly the same, while in many articles (e.g. http://msdn.microsoft.com/en-us/library/ms978388.aspx) the performance of DataReader is described as much better (even 30 times better) than DataAdapter/DataSet.

We're wondering if this happens because we're using ODP.NET instead of Microsoft implementation.

Is there anyone who can help us interpret these results?

Thanks,
Andrea
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2010
Added on Jan 26 2010
0 comments
2,801 views