What is connection pooling

Question

What is connection pooling? And name the pre-requisites used for connection pooling?

Answer 1

Connection pooling refers to task of alignment database connections in the cache to build them reusable since opening new connections each time to the database is very time-consuming procedure. So, connection pooling facilitates us to recycle previously existing and the active database connections, each time required, and increase the performance of application.
We can enable or disable connection pooling in the application through setting a pooling property to either true or false in the connection string. By default, it is enabled in the application.

Prerequisites used for connection pooling are:

• There should be several processes to share similar connection describing the similar security settings and parameters.

• Connection string have to be identical.