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!

Extremely slow performance with ODP.NET

389085Mar 14 2003 — edited Mar 20 2003

I have a stored procedure that runs 100 times sequentially and it returns around 450,000 records in the database. The ODP.NET provider executes that in about 12 minutes, whereas the DataDirect ORA Provider executes it in about 1.5 minutes. Anyone else experienced this slowness? I am finding that on the intense queries I am writing, Oracle is very very slow. Thanks for any responses!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2003

Added on Mar 14 2003

#odp-net

9 comments

1,976 views