[Website performance] a perfect website 101 indicators of the Six

Source: Internet
Author: User
Tags end sql net return website performance
Performance | website

The performance of the site is related to the user access experience, so that the site to support more users, so that each user's waiting time shorter is our goal. Performance is enhanced by database optimization, efficient HTML code rendering, and content caching. Here are some rules for improving Web site performance:

Optimize the design of the database

Rational use of Index, use of efficient SQL statements, reduce database table full table scan, only return the necessary data, these are very effective database optimization methods, database is often a Web site performance bottlenecks, you need to continue to optimize the database, every little bit of performance improvement, The cumulative result will be a qualitative change.

Use Store Procedure to exchange data between database and website business layer

Stored Procedures (store Procedure) perform far more efficiently than dispersed SQL statements. As long as your database supports Store Procedure you should use it as a data interchange channel between the business logic end of the Web site and the database end.

Pagination returns the records in the database without using the business layer's paging

When you return a large number of data records, you should use the paging mechanism to page through the data, you need to page in the database, in the business layer paging will lead to a large number of duplicate data between the data layer and the business layer, resulting in performance bottlenecks.

Using mature optimized Web page rendering techniques

asp.net, PHP, JSP, Ruby, and CGI can act as HTML rendering engines for the site's presentation layer, and you can choose the right platform for your needs. It should be noted that a platform such as ASP.net, in order to meet the vast majority of applications and minimize the amount of user code, uses a number of techniques that may degrade performance, such as View state, which you can turn off to improve page rendering and execution efficiency. In fact, we used the direct Render method in Comsharp CMS, put aside the ASP.net page lifecycle model, rendering HTML code directly to generate Web pages, and achieved very good performance.

Reduce Http requests using XHTML + External CSS + External Javascript

You should separate the content, adornments, and behavior of the page, content as pure XHTML, as an external CSS file, and act as an external JavaScript file, and the advantage of this model is that the browser can cache external CSS and JavaScript, each time with just the server-side request XHTML content, greatly reduces the request size of the page, has a great help for performance improvement.

Use clean code (XHTML, Javascript, CSS)

Your HTML code, Javascript, and CSS files need to contain clean code, clean, compliant code not only short, but also reduce the burden of browsers, browsers do not need to carry out a variety of fault-tolerant analysis, completely in accordance with the standard output, implementation efficiency greatly improved.



Related Article

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.