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

    Problem with DataReader

    srikar
      Hi,

      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-11.1.0.7.10

      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 11.1.0.7.10 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 (11.2.0.3) to ensure you are not hitting an old bug. ODP.NET 11.2.0.3 is compatible with an Oracle 11.1 DB.

          Performance issues are very difficult to diagnose via discussion forum.