1 Reply Latest reply: Jan 19, 2012 12:07 AM by Alex Keh - Product Manager-Oracle RSS

    Problem with DataReader


      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 - Product Manager-Oracle
          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.