ASP.NET Page is very slow. What will you do to make it fast

[John Irron]

Please,


Give me that relevant answer.

[sagabizsolutions]

Find out who is slow, is it the application or database: If the page is running SQL queries or stored procedures, run those in the database and check how long do they take to run. If queries take most of the time, then you know that you need to adjust queries for better performance. To refine queries, there are many ways and I have listed some of them below.
a) Check if there are indexes to help the query
b) Select only the required columns, avoid Select *.
c) Check if there is a possiblity to reduce the number of joins
d) If possible use NO LOCK on your select statements
e) Check if there are cursors and if you can replace them with joins
Another factor to slow down asp page is view-state. so developer should check view state of each control and possibly turn off unnecessary view state from certain controls. specially gridview control's view state will take much time to reload.

Thanks and Regards
Sagabizsolutions