Answer Posted / ramesh s
In software engineering, a connection pool is a cache of
database connections maintained by the database so that the
connections can be reused when the database receives future
requests for data. Connection pools are used to enhance the
performance of executing commands on a database. Opening and
maintaining a database connection for each user, especially
requests made to a dynamic database-driven website
application, is costly and wastes resources. In connection
pooling, after a connection is created, it is placed in the
pool and it is used over again so that a new connection does
not have to be established. If all the connections are being
used, a new connection is made and is added to the pool.
Connection pooling also cuts down on the amount of time a
user must wait to establish a connection to the database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is meant by method chaining?
difference between ejb,struts,hibernate,spring and jsp
whats is mean by connectionpooling
What is the purpose of the finally clause of a try-catch-finally statement?
Define prototype?
Why are my checkboxes not being set from on to off?
Why does the tag url-encode javascript and mailto links?
What are transaction attributes?
Name the eight primitive java types.
Difference between hashmap and hashtable?
what is Activation Instantinator?
Can I use javascript to submit a form?
What event results from the clicking of a button?
What is the purpose of the wait() method?
Describe, in general, how java's garbage collector works?