How can I get the query to execute in my .NET application as quickly as in SSMS?
-
Hi Exports, I have an asp.net 2.0 application, which is very slow in performance. we have triggered the issue down the line, we are surprised with issue. The application used lot of database operations and respective stored procedure have lot of complicated business logic, but the stored procedure won't take much time to execute on SSMS(SQL Server) but when we access same stored procedure through the application it take huge time. please suggest me how i can resolve the time consuming problem.
-
Hi Exports, I have an asp.net 2.0 application, which is very slow in performance. we have triggered the issue down the line, we are surprised with issue. The application used lot of database operations and respective stored procedure have lot of complicated business logic, but the stored procedure won't take much time to execute on SSMS(SQL Server) but when we access same stored procedure through the application it take huge time. please suggest me how i can resolve the time consuming problem.
There are lots of good suggestions in this article[^] for you to try.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Hi Exports, I have an asp.net 2.0 application, which is very slow in performance. we have triggered the issue down the line, we are surprised with issue. The application used lot of database operations and respective stored procedure have lot of complicated business logic, but the stored procedure won't take much time to execute on SSMS(SQL Server) but when we access same stored procedure through the application it take huge time. please suggest me how i can resolve the time consuming problem.
Are you sure it is the sql that is taking longer? If you are displaying results into a grid and have lots of results I'll bet the slowdown has nothing to do with SQL but is actually the browser trying to render all that html. This is a common problem.
There are only 10 types of people in the world, those who understand binary and those who don't.
-
Are you sure it is the sql that is taking longer? If you are displaying results into a grid and have lots of results I'll bet the slowdown has nothing to do with SQL but is actually the browser trying to render all that html. This is a common problem.
There are only 10 types of people in the world, those who understand binary and those who don't.
-
Hey SQL query works on very efficient manner, my stored procedure won't take more than 2sec to execute, but the issue with application
