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 ado.net in mvc?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is the namespaces being used to access oracle database?
Which is faster dataset or datareader?
Explain ODP.net
What is ado object model?
Which keyword is used to accept variable number of parameters?
What are the several execute methods of ado.net?
What is a control toolbox?
How will you fill the gridview by using datatable object at runtime?
What are the Data providers in ADO.Net?
Why is stored procedure used in ado.net?
Define data access layer?
What is partial class?
Define the executescalar method?
