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
For which statements does it make sense to use a label?
Can I import same package/class twice? Will the jvm load the package twice at runtime?
What is clustering? What are the different algorithms used for clustering?
What are the purpose of introspection?
To identify IDL language what mapping mechanism is used?
Explain the steps in details to load the server object dynamically?
What is an abstract method?
what are the advantages of JTA over JTS?
Should synchronization primitives be used on bean methods?
What is scalable, portability in the view of J2EE?
Difference between DurableSubscription and non- DurableSubscription?
Where can I ask questions and make suggestions about seam?
What is a session? Can you share a session object between different theads?
How task's priority is used in scheduling?
how i secure my site with the https protocol.what are the steps?
