Ensure Efficient Usage of Connections

You should be very careful while establishing database connections from your Web-based application.

MDAC 2.0 (Microsoft Data Access Components) provides automatic connection pooling behind the scenes. Connection pooling in OLE DB is enabled by an OLE DB service component that works with the OLE DB provider that you are using to talk to the database. Whenever you call Open and Close methods on the Connection object, OLE DB internally gets and drops back the connection to a single pool of connections so that it can be reused by other components in the application.

While designing your application, you should always make sure that you acquire resources as late as possible and release them as early as possible. This golden rule applies to database connections as well and your application should acquire connections late and should release them as early as possible.

If you use this approach, your application will perform better while making efficient usage of the resources. I suggest that your middle-tier components should establish and release connections on a per-method basis.

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

Overview

The Latest

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

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may