Sams Teach Yourself ADO.NET in 24 Hours

Hour 17. Using Connection Pooling

Many design considerations must be addressed when building Web-based applications, especially Web applications that need to handle a large number of users and promise great scalability. Deciding how to use a technical design feature such as “connection pooling” can make the difference between a slow and clunky Web app or a fast and sleek Web app. Connection pooling deals with how the database connections are utilized (used and reused) to enhance the overall efficiency of the whole system. In fact, this one little feature translates directly into being able to support a much larger number of users with minimum performance impact. Ah, the promise is fulfilled.

Basically, the Microsoft .NET Framework has taken the ...