How can I check the reason why An aspx page is slow?

Source: Internet
Author: User

How can I check the reason why An aspx page is slow?

I recently read an article about how to speed up An aspx page. This is a common interview question. The original question is from this website.

There are many causes for this problem. We need to troubleshoot the problem step by step to locate the problem.

1. Find out whether the interaction between the website itself and the database is slow. If the interaction with the database is executed during this page, extract these SQL commands and run them on the Database Console. If the execution of these statements on the Database Console is still slow, it indicates that the problem occurs in the interaction with the database. In this case, you need to consider optimizing these SQL statements.
A. Check whether an index is created to increase the query speed.
B. Using select * will reduce the efficiency.
C. Use the join keyword as few as possible.

2. If SQL statements are executed quickly, the problem may be caused by the website itself. In this case, we need to view each Page event one by one to determine which one is slow. There is a tracing tool in ASP. NET. We can use this tool to view how long each event took. Set Trace = "true" in page directive, and then you can see the time parameter list of each event at the bottom of the page.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.