How can ASP + SQL can run faster

xiaoxiao2021-03-06  74

One. Database design requirements 1. The database design is reasonable to reasonably a table's capacity to build a new table 2. Database operations use stored procedures, improve efficiency, which is good to do the foundation 3. Establish an index properly. 4. Field design, as little as possible, try to try. If this requires, it can be solved by other channels. (Key in the designer's program algorithm) II. ASP coding requirements 1. Try to coding script classes provided by ASP. 2. Considering the technology of ASP connection ADO on the database. Introduced the disconnected database method of ASP.NET on the algorithm. Use the ASP script class to write data base classes similar to the DataSet object function. The aim is to achieve break-open read, delete, and change to each of the data between the page. 3. The server is written by ASP code, and the browser is written with JavaScript. Destination ASP encoding is only responsible for processing data, and JavaScript encoding is operated on data. It is not a shortcomings of the ASP in the mold to pull. 4. TheaSP security must prevent hackers from injection attack. With a secure project security class, and log class with a script component to make up for ASP in security defects. http://vod.gamesoft.com.cn is what I wrote based on this requirement (registered users can support 6 million to 12 million, and 5,000 online database CPUs do not exceed 20%, the web server does not exceed 40% ), Can also be improved in the speed of JSP Javabean, but also said. The above is the experience I wrote ASP, and I wrote it.

转载请注明原文地址:https://www.9cbs.com/read-121480.html

New Post(0)