35 users online (2 members and 33 guests)  


  Results 1 to 2 of 2

Related

  1. How to make the page load at the bottom?    Forum: HTML Forum
    Replies: 11
  2. How do you make an intro page    Forum: HTML Forum
    Replies: 2
  1. #1
    John Irron's Avatar
    New User

    Status
    Offline
    Join Date
    Nov 2011
    Posts
    5

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

    Please,


    Give me that relevant answer.

  2. #2
    sagabizsolutions's Avatar
    New User

    Status
    Offline
    Join Date
    Apr 2015
    Posts
    2

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

    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