Connection Pool-connection pools

1. Why use the connection pool?

-It takes time and resources to create a connection.
-Connection pools can be used to maintain connections after a specific page is run.
2. Comparison between using a connection pool and not using a connection pool

3. Connection Pool in ADO. net

-If oledbconnection is used, the connection pool will be providedProgramAutomatic Processing

-If the sqlconnection class is used, the connection pool is implicitly managed, but options are also provided to allow you to manage the pool by yourself.

Specify in the connection string:

A. Pooling = true; // The default value is true.

B. Connection lifetime = 5; // The default value is 0.

C. Min pool size = 1; // The default value is 0.

D. Max pool size = 50; // The default value is 100.