Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in [path]/includes/class_bootstrap.php(430) : eval()'d code on line 110
What is Connection Pooling

Results 1 to 3 of 3

Thread: What is Connection Pooling

  1. #1
    Senior Member
    Join Date
    Jun 2015
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

  2. #2
    Junior Member
    Join Date
    Aug 2016
    Location
    USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In software engineering, a connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required.

  3. #3
    Member
    Join Date
    Dec 2018
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In software engineering, a connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required. Connection pools are used to enhance the performance of executing commands on a database.

Similar Threads

  1. what is object pooling?
    By beingchinmay in forum Web Programming
    Replies: 0
    Last Post: 03-08-2016, 11:52 AM
  2. Replies: 0
    Last Post: 09-24-2015, 02:02 PM
  3. Error Establishing a Database Connection
    By Emerson1 in forum OFF Topic Forum
    Replies: 0
    Last Post: 03-01-2013, 06:43 PM
  4. I will get you 100 business connection on GoBuzz.Me
    By yumnajqs in forum Marketplace: Sell, Buy & Trade
    Replies: 0
    Last Post: 01-09-2013, 08:38 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •