What is connection pooling?

Question

what is connection pooling? how we can use it? and why? plz reply with example.

Monika Sinha · Answer

Connection pooling is the ability of re-use your connection to the Database. This means if you enable Connection pooling in the connection object, actually you enable the re-use of the connection to more than one user. The connection pooling is enabled by default in the connection object. If you disable the connection pooling, this means the connection object which you create will not be re-used to any other user than who create that object.

Munir Shaikh · Answer

Hi, Here is URL: http://www.c-sharpcorner.com/UploadFile/munnamax/connectionpooling08112007062332AM/connectionpooling.aspx Hope this will be useful. Regards, >>Munnamax

Mahesh Chand · Answer

Rohit, On C# Corner, we have a search control. If you type your keyword, say "connection pooling", you will see many articles. Try that. Here is an article on CP. http://www.c-sharpcorner.com/UploadFile/dsdaf/ConnPooling07262006093645AM/ConnPooling.aspx

What is connection pooling?

Answers (3)