performance issues(OracleDataReader & Adapter)

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle Ref Cursor Issue in ADO.NET 10
ADO.NET query execution much slower than SQL Management Studio 5
Performance issue with vS2005 2
SP in Typed Dataset Timeout vs Management Studio Good Performance 9
Sproc performance over vpon 12
Data Adapter Problem? 2
Web Service max out at 20 SQL connections 12
SqlClient TimeOut Issues In Asp.Net Only 7

Top