aso questions

Results 1 to 2 of 2

Thread: aso questions

  1. #1
    Abhijit Guest

    Default aso questions

    What is connection pooling?

  2. #2
    Join Date
    Dec 1969

    Default RE: aso questions

    When you create a connection to a database, that is a very expensive operation. It takes a long time (figuritively speaking) to open up a connection. So what connnection pooling in effect does is create a default pool of open connections to the database. When an application requests a connection, one of the already opened ones are handed to the application. When the application closes the connection, the connection is not really closed, just moved back into the pool of available connections. <BR><BR>In summary, connection pooling leads to increased performance because connections are made in advance, rather than having a connection object be opened each time a request to the database is made.<BR><BR>Connection pooling is on by default with IIS 4.

Posting Permissions

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