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
Which parameter of ConnectionString is used to specify the name of the database?
What are the data access namespaces in .NET?
What is microsoft ole db provider for sql server?
Why is ADO.NET serialization slower than ADO ?
Which object is used to add relationship between two Datatables?
Explain sqlconnection object?
What are the essential features of ado.net?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What are the drawbacks of using ado.net?
Define data adapter?
What are the main differences between classic ado and ado.net?
How to check if a datareader is closed or opened? IsClosed()
Which namespaces are used for data access?
Explain the advantages and disadvantages of using datalist?
What is ado control?