Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / madhunathanv
Connection pooling increases the performance of Web
applications by reusing active database connections instead
of creating a new connection with every request.
Connection pool manager maintains a pool of open database
connections. When a new connection requests come in, the
pool manager checks if the pool contains any unused
connections and returns one if available. If all
connections currently in the pool are busy and the maximum
pool size has not been reached, the new connection is
created and added to the pool.
When the pool reaches its maximum size all new connection
requests are being queued up until a connection in the pool
becomes available or the connection attempt times out.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to find the given query is optimised one or not?
Where is adodb dll located?
What are the advantages of ado.net?
What is a datareader object?
What is ado.net in mvc?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is Data Provider?
What is different between sqlcommand object and command behavior object?
How to pass multiple tables in datasets simultaneously?
What is the hierarchy of data in databases?
What is connection pooling and what is the maximum pool size in ado.net connection string?
What is ado.net objects?
What are the advantage of ado.net?
Explain the different row versions available in table?
How can we load multiple tables in to dataset?
