Explain Connection Pooling
In this article I will explain about Connection Pooling.
Introduction
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
Server=server_add:port_num;Database=database_name;uid=user_name;Password=password;Pooling=False;
|
Time in Pool defines how many seconds the connection can remains idle in the pool before its removed from the pool.
Syntax
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