Connection Pooling

What is connection pooling?

Connection pooling is process of taking a connection from a pool of connections, once connection is created in the pool any application can re-use that connection.

Why connection pooling?

The main purpose of any application is provide fast & efficient solution, mainly the perform of the system/application depends on the database activity. Making a connection to the database is time consuming (which depends on network speed & memory) when pooling is true the request for database connection can be fulfilled from the pool instead of re-connecting to the database, which will increase database performance.

It has taken from the Article By Munir Shaikh

http://www.c-sharpcorner.com/UploadFile/munnamax/connectionpooling08112007062332AM/connectionpooling.aspx