DataReader vs DataAdapter Performance Comparison with ODP.NET
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