what is meant by connection pooling and event pumbling in
ado.net
Answer Posted / gyany
Connection Pooling:-
Connection pooling reduces the number of times that new
connections need to be opened. The pooler maintains
ownership of the physical connection. It manages
connections by keeping alive a set of active connections
for each given connection configuration. Whenever a user
calls Open on a connection, the pooler looks to see if
there is an available connection in the pool. If a pooled
connection is available, it returns it to the caller
instead of opening a new connection. When the application
calls Close on the connection, the pooler returns it to the
pooled set of active connections instead of actually
closing it. Once the connection is returned to the pool, it
is ready to be reused on the next Open call.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is the use of data grid?
how can implement dropdownlist in particular of dataset when try to update?
Command objects uses, purposes and their methods.
What are the types of databinding?
What are the advantage of ado.net?
Is ado.net dead?
What are typed and untyped dataset?
What are the major difference between classic ADO and ADO.NET?
Define the executescalar method?
What is the usage of the dataset object in ado.net?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What is full form of ado?
What is ole used for?
What are the advantages using ado.net?
Which database is the ado.net?