Slow ASP Website opening Solution

The portal website of our school is made of ASP + ACCESS database. After the website has been running for a long time, it will be very slow to open. Sometimes it is basically hard to open, and there are no breakthroughs to find reasons from multiple parties. I accidentally discovered the following solution to solve the problem. I posted it to everyone first.

 

(1) set an independent website "application pool" and do not use any default one.

(2) set the "application pool" attribute.

Make a scheduled task and let the system automatically recycle the working process. For example:

00: 00

08:00

12: 30

Reclaim system processes at these three points of time. The website is recycled at every morning and recycled at noon. We believe that the website access speed will be improved.

 

(3) set the number of web garden Processes

Theoretically, the maximum number of worker processes in the Web garden can be set very large. The maximum value can be 4000000.

However, there is no need to set this value so large. For example, I set four.

The setting is too high and the CPU usage is very high.

This is what happens in your spare time. CPU usage is not very high.

 

After the preceding steps, the website can be opened quickly.

 

(4) Access Database Optimization

When the ACCESS database runs for a long time, the volume increases. This will affect the Website access speed. Therefore, the following methods can be used for optimization. Download the mdb database file to the local machine and compress it with Access2000.

 

After compression, the size of the database will decrease, which will help speed up Website access.

However, the best way is to upgrade the Access database to Ms SQL2000, Oracle, MySQL, and other large databases.

 

(5) Delete unnecessary "log" data in the database

For example, our website records background users and visitor access records. After a long time, the logs occupy a large part of the space.

 

Note: After deleting log data, remember to perform a "compressed database operation"

 

(6) server anti-virus software may also affect the Website access speed (possibly !!!)

I use NOD32 anti-virus software. I don't know why it slows down as long as I use web access protection together. Maybe it is because of the time used for data detection.

 

So far! Success.

 

In addition to the above methods, you can also use squid as the proxy for website acceleration. Many websites now use this technology and try again later.