Connection Pooling in C#

Question

Hi friends  I want to know that what is the meaning of connection pooling? What is a pre-requisite for connection pooling?

Satyapriya Nayak · Answer

Hi Amit connection pooling is a cache of database connections maintained so that the connections can be reused when future requests to the database are required. Connection pools are used to enhance the performance of executing commands on a database. Opening and maintaining a database connection for each user especially requests made to a dynamic database-driven website application is costly and wastes resources. In connection pooling after a connection is created it is placed in the pool and it is used over again so that a new connection does not have to be established. If all the connections are being used a new connection is made and is added to the pool. Connection pooling also cuts down on the amount of time a user must wait to establish a connection to the database. pre-requisite for connection pooling Multiple processes must agree that they will share the same connection where every parameter is the same including the security settings. The connection string must be identical. Thanks

Krishna Garad · Answer

refer this article Understanding Connection Pooling in ADO .NET