There are too many reading records in the database table. If your SQL statement is not optimized and the machine access speed is too slow, this problem will occur. Optimize the SQL statement and use the stored procedure to solve the problem.
I hope the following methods can help you solve this problem.
Method 1
You can add time for allowed ASP scripts to specific websites. In this way, set the Internet Information Server (IIS) metadatabase value:
1. Open the Internet Service Manager.
2. Expand the tree and right-click the default web site (or problematic site ).
3. Click properties.
4. Click the Home Directory tab.
5. ApplicationProgramSet and click Configure.
6. Click the app options tab.
7. The ASP script overvalue is increased to a number to prevent script timeout from being high enough.
Method 2
You can increase the time allowed to execute ASP scripts on all web sites. In this way
1. Open the Internet Service Manager.
2. Right-click the computer name.
3. Click properties.
4. select WWW Service from Master attribute, and click Edit.
5. Click the Home Directory tab.
6. In application settings, click Configure.
7. Click the app options tab.
8. The ASP script overvalue is increased to a number to prevent script timeout from being high enough.
Method 3
The server. scripttimeout attribute can be used for programming to increase the scripttimeout attribute value at the ASP page level. For example, if it takes 3 minutes to pass the preceding process, add the script to the following line on the ASP page: Server. scripttimeout = 180
<% Server. scripttimeout = 180%>