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 would you connect to a database by using .NET?
What is difference between ado.net and asp net?
What is maximum pool size in ado.net connection string?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is a datareader object?
Define bubbled event?
Explain the basic use of "dataview" and explain its methods.
What are the advantages of oledb compared with other classes?
Describe connection object in ado.net
Explain ado.net features? Benefits? Drawbacks?
What is the role of the dataset object in ado.net?
What is the difference between a datareader and a dataset?
What is the use of adodc?
What is difference between sqldatareader and sqldataadapter?
What is the difference between sqlcommand and sqldataadapter?
