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
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 - Oracle_Product_Manager Expert
    Currently Being Moderated
    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.

Legend

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