performance issues(OracleDataReader & Adapter)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to populate grid using OracleDataReader and it seems
Datareader.Read() is taking alot more time in reading the resultset(around 12
seconds in reading 50 records).
the same sql statement in SQL plus is taking less than 2 seconds.

I tried using sqldataadapter.Fill but this is also taking a lot more time
than expected.

If any one has any suggestions to improve the performance can you please let
me know.

Thanks
 
Please ignore this post, by mistake my oracle hint was missing in the query
used in the application which was the cause for the bad performance.

Thanks
 
Back
Top