Sams Teach Yourself ADO.NET in 21 Days

Pooling Connections

In enterprise applications, it is particularly important to pay attention to issues that influence the scalability of your application. One of the primary issues involved is the handling of connections. This is because connections are generally a limited resource that consumes overhead on the data store. For some time, the idea of connection pooling has been used to achieve scalability by allowing an application thread to free a connection as soon as it is done using it and returning it to a pool of connections that other threads in the same or a different process may use. The overall result is that fewer connections need to be maintained by the data store. In other words, the ratio of connections to users is less than 1 to ...