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
What is ado.net object model?
What are datareaders?
What is difference between datagridview and datagrid control in winforms?
What is variable view?
What is the difference between ado.net and entity framework?
What are disadvantages of microsoft-provided data provider classes in ado.net?
What is oledb connection?
What is ole data type?
What is dataset and datatable in ado.net?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What is ado object model?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
What is full form of ado?
If we are not returning any records from the database, which method is to be used?
What are the usages of the command object in ado.net?
