none
OracleDataReader.read() take very long time RRS feed

  • Question

  • I have an Oracle store procedure, when we retrive data by the store procedure, it quite slow,
    here is the code:

    object

     

    [] vArray = new object[count];

     

    for (;reader.Read();)

    {

    reader.GetOracleValues (vArray);

     

    for (int j=0;j<count;j++)

    {

     

    if (vArray[j].ToString ()=="Null")

    vArray[j]=

    null;

    }

    dt.Rows.Add (vArray);

    }

    actually the reader.read() take about 10 minutes and it return just 71 rows, we try

    OracleDataAdapter.Fill() but not helped

    we run the store procedure in SQL plus, it finished immidiately.
    we run the query in the store procedure
    in sqlplus, all result retrieved at about one minute,
    and use my another program run the query (in .NET framwork 3.5)
    which using OracleDataAdapter.Fill() just take one minute to show the result
    we also check the query exetion time in the store procedure, it actually just run several ticks

    can anybody help for the data retrieve performance from Oracle server?

    Thursday, August 27, 2009 2:50 PM

Answers

All replies