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
What is the advantage of ado.net?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is commandbuilder in ado.net?
What are the parameters that control most of connection pooling behaviours?
How is it possible to get 2 tables of data at a time by using data reader?
Explain the basic use of "dataview" and explain its methods.
Explain how to find the given query is optimised one or not?
Describe briefly an ADO.NET Dataset ?
What is a data control clerk?
What is the difference between Data adaptor and Data set?
What are the benefits of ADO.NET?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What are the difference between readonly vs. Const?
What is difference between ado and other data object?
What is dao and ado?
