Sams Teach Yourself ADO.NET in 24 Hours

What Is Connection Pooling?

In brief, connection pooling allows applications to reuse an existing database connection from a pool of already established connections, instead of having to repeatedly re-establish new connections to that same database. Establishing database connections is fairly expensive if you compare that aspect to the overall work that will be handled with a database connection in the first place. It is expensive because when a user establishes a connection to a database, the user must be identified and pass authentication (security) before the connection is even allowed. Repeating this over and over puts a huge burden on the database management system and the server, not to mention the overall network traffic that results. ...