If your ASP application is interacting with the database (I want to get the database, do you want to use ASP?), Using the connection buffer pool will greatly improve the performance of the database. Establish a time spent on the data connection and System resources are not insignificant. When each page that needs to establish a database connection instance is accessed, a new connection object will be created and destroyed after the page is executed, and if there are many people access your site at the same time, Visitors will find system performance.
The connection buffer maintains a connection example so that users can use the database connection at any time. For example, you have an ASP page created a connection to the SQL database, remove some data from the database, and display it on the web page. If the connection buffer pool is not turned on, the ASP will work like this:
Create a database connection
Submit a query request to the database
retrieve data
Display Data
Destroy
Users will perform these operations each time you click on the page. However, when the connection buffer pool is enabled, the relevant steps are as follows:
Check if there is an unused connection in the buffer pool
If there is, use this connection, if not, create a new connection
Submit a query request to the database
retrieve data
Display Data
Bush pool
Repeat the connection can save a lot of system resources when the page needs to establish a database connection.
Now let's take a look at how to let the ASP application use the connection buffer pool. First, you have to open the connection buffer in the ASP registration item in the registry, and then set SQL Server to use TCP / IP Sockets.
To enable the connection buffer pool in the registry, you have to run the regedit, find this registry key:
HKEY_LOCAL_MACHINE / SYSTEM / CURRENTCONTROLSET / SERVICES / W3SVC / ASP / Paramet
ERS
(If you don't have this button, you will build one)
Find the StartConnectionPool key, change the key value from 0 to 1. So this is changed, ADO and ASP will enable the connection buffer pool.
The final step is to set SQL Server to use TCP / IP Sockets. Start SQL Server Manager, set the default network settings to TCP / IP Sockets
(Note: Connection Buffers are invalid for ASP applications for Access for background databases.) Excerpted from: http://www.7i24.com
