What is Connection Pooling?

  • 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 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 n w one v ry time


a connection request to the database is made. When the connection is closed or dispos  d, it is r  turn d


to the pool and remains idle until a request for a new connection comes in.


  • The pool can house connections up to the maximum limit as specified in the connection string that was used to connect to the database.


  • Advantage of using Connection Pooling is an improvement of performance and scalability


  • Disadvantage is that one or more database connections, even if they are currently not used, are kept open.


Facebook Comments

About admin

Check Also

ASP.NET Interview Question Part-2

1) How does the cookies work in asp.net? When a cookie is created it will …

ASP.NET Interview Question Part-1

1) What’s a bubbled event? The event processing routine for each object in complex control …

ADO.NET interview Questions-Part 2

1.What are the advantages of ADO.NET? The advantages of ADO.NET are as follows:- It is …

Leave a Reply

Your email address will not be published. Required fields are marked *