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!

OracleDataAdapter.Fill(Dataset) very slow

782206Jun 30 2010 — edited Apr 12 2011

[http://www.itsconsulting.fr|http://www.itsconsulting.fr] Hi there,

I need to optimize a code that retrieves data from an Oracle Database.
The code is using OracleDataAdapter.Fill(Dataset)

The version of the Oracle.DataAccess.dll is 2.111.7.20 (I think it is the latest), and I am using as well Visual Studio 2008.

The stored procedure is returning 6 RefCursors as out parameters and takes two parameters as input, in oracle the stored procedure is executed in less than a second. However the Fill method takes more than 10 seconds which for a WebApplicaiton is not acceptable.

Any help on this? is the ExecuteReader a better option? how do I use it ?

Regards,
Stefan
http://www.itsconsulting.fr

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2011

Added on Jun 30 2010

#odp-net

3 comments

4,867 views