This discussion is archived
1 Reply Latest reply: Jan 18, 2012 10:07 PM by Alex_Keh - Oracle_Product_Manager RSS

Problem with DataReader

srikar Newbie
Currently Being Moderated

I have a query that executes in 3 to 4 seconds to fetch 500 records but when i am reading the result using IDataReader
it is reading first 22 rows very fastly after reading 22nd row it is taking 1 minute time and reading next 22 rows fastly
like this for every 22 rows it is taking 1 minute.

I'm using Oracle-11g r1 DB and ODP.NET-

please help me....

Edited by: srikar on Jan 31, 2012 10:26 AM

Edited by: srikar on Jan 31, 2012 10:27 AM

Edited by: srikar on Feb 28, 2012 9:25 AM
  • 1. Re: Problem with DataReader
    Alex_Keh - Oracle_Product_Manager Expert
    Currently Being Moderated
    ODP.NET was a beta version IIRC. I don't know what your specific problem is necessarily. First thing I generally recommend to people is to upgrade to the latest ODP.NET version ( to ensure you are not hitting an old bug. ODP.NET is compatible with an Oracle 11.1 DB.

    Performance issues are very difficult to diagnose via discussion forum.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points