dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: Enterprise
Expertise: Beginner
Aug 1, 1999

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Use Connection Pooling to Enhance Performance

You can experience a great increase in database performance if you utilize connection pooling. Creating a connection to a database takes a lot of time and resources. If every you create a connection instance for every page, a new connection must be created and then deleted once the page executes. Users will notice the loss in performance if there are many people hitting your server simultaneously. Let's look at how we can make sure our ASP applications use connection pooling.

1. Make sure your ASP registry settings have connection pooling enabled. First, you will need to run the REGEDIT program and alter the following registry entry:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\W3SVC\ASP\Parameters
If this value is not set, go ahead and insert this key into your registry.
Then, find the StartConnectionPool entry and change the value from 0 (zero) to 1 (one). Then, ADO and ASP will utilize connection pooling.

2. Make sure you

Jai Bardhan
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date