Explain Connection Pooling

In this article I will explain about Connection Pooling.
  • 2008


Connection Pools is a cache of database connections maintained so that connection 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. Pooling results in more efficient resource allocation.

Connection string to define the connection pooling pool size

Server=server_add:port_num;Database=database_name;uid=user_name;Password=password;Max Pool Size=100;Min Pool Size=10;

The user can also disable pooling. Connection string to disable pooling is given below


Time in Pool defines how many seconds the connection can remains idle in the pool before its removed from the pool.


Server=server_add:port_num;Database=database_name;uid=user_name;Password=password;Connection Lifetime=60;

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answer here


More Articles

© 2020 DotNetHeaven. All rights reserved.