V
Vincent Keller
I am trying to execute a time-consuming stored procedure in my application.
When I run the stored procedure through Query Analyzer, it takes some time
but returns results in about 15-20 secs. However, when I run the same
procedure by using ExecuteScalar/ExecuteNonQuery it seems to take a lot more
time ( ~ 2-3 mins).
I have ensured that I am not keeping the connection open for a long time as
well as used Indexes where required but that hasn't helped a lot.
Are there some known performance differences in executing a query (stored
procedure) directly through Query Analyzer and through ADO.NET ?
Any recommendations for such a scenario to speed up query performance ?
When I run the stored procedure through Query Analyzer, it takes some time
but returns results in about 15-20 secs. However, when I run the same
procedure by using ExecuteScalar/ExecuteNonQuery it seems to take a lot more
time ( ~ 2-3 mins).
I have ensured that I am not keeping the connection open for a long time as
well as used Indexes where required but that hasn't helped a lot.
Are there some known performance differences in executing a query (stored
procedure) directly through Query Analyzer and through ADO.NET ?
Any recommendations for such a scenario to speed up query performance ?