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 serialization and de-serialization in .net?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
How can we perform transactions in .net?
How to identify the controls which can be used for binding data?
Which parameter of ConnectionString is used to specify the name of the database?
What is csdl entity framework?
Explain the various objects in dataset.
What are disadvantages of microsoft-provided data provider classes in ado.net?
Is ado.net an orm?
How would you connect to database using .NET?
What is linq and entity framework?
What is the meaning of object pooling?
What is the purpose of using adodb?
Explain the difference between data reader and data set?
Explain the namespaces in which .net has the data functionality class.