Connection Pooling

Question

Hi... I want to know about the connection pooling in ADO.NET with example ? Thanks....

Prabhu Raja · Answer

Hi, What is connection pooling? Connection pooling is process of taking a connection from a pool of connections, once connection is created in the pool any application can re-use that connection. Why connection pooling? The main purpose of any application is provide fast & efficient solution, mainly the perform of the system/application depends on the database activity. Making a connection to the database is time consuming (which depends on network speed & memory) when pooling is true the request for database connection can be fulfilled from the pool instead of re-connecting to the database, which will increase database performance. It has taken from the Article By Munir Shaikh http://www.c-sharpcorner.com/UploadFile/munnamax/connectionpooling08112007062332AM/connectionpooling.aspx

Vineet Kumar Saini · Answer

Thanks Prabhu raja Ji....

Satyapriya Nayak · Answer

Hi Vineet, Please refer Our recommended articles. Thanks

Javeed M Shaikh · Answer

Hi Vineet, Please refer to the following C# Corner articles: http://www.c-sharpcorner.com/UploadFile/mahesh/85/ http://www.c-sharpcorner.com/UploadFile/4d56e1/8748/

Connection Pooling

Answers (4)