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_MACHINESystemCurrentControlSetServicesW3SVCASPParameters
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

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS