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 the difference between long.class and long.type?
Describe responsibilities of Activator?
How are commas used in the intialization and iteration parts of a for statement?
What is scalable, portability in the view of J2EE?
What is threadfactory?
Explain phantom read?
Explain about RMI Architecture?
What is the relationship between the canvas class and the graphics class?
What is local interface. How values will be passed?
What are the different methods of identifying an object?
What is metaspace?
why static class in java
What is the difference between ear, jar and war file?
What must a class do to implement an interface?
Name the eight primitive java types.