WHAT IS A PRE-REQUISITE FOR CONNECTION POOLING?

Anoop Singh

Total Post:37

Points:185
Posted by  Anoop Singh
C# 
C#
 1302  View(s)
Ratings:
Rate this:
  1. Pushpendra Singh

    Post:241

    Points:1205
    What is a pre-requisite for connection pooling?

    Connection Pooling can increase the database performance to a huge extent.
    A Connection Pool is a container of open and reusable connections. A Connection Pool is released from the memory when the last connection to the database is closed. The basic advantage of using Connection Pooling is an improvement of performance and scalability while the main disadvantage is that one or more database connections, even if they are currently not being used, are kept open. The Data Providers in ADO.NET have Connection Pooling turned on by default; if you need to turn it off, specify Pooling = false in the connection string being used. Connection Pooling gives you an idle, open, reusable connection instead of opening a new one every time a connection request to the database is made. When the connection is closed or disposed, it is returned to the pool and remains idle until a request for a new connection comes in. If we use Connection Pooling efficiently, opening and closing of connections to the database becomes less resource expensive.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!