Explain Connection Pooling

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

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.