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 RMI and Socket?
what is the use of State Factories?
What are the benefits of detached objects?
when A client sent a request to the server to open facebook page and close the browser after this request .at that time the same user do login by using a different browser then that session id will exist or not for the same client??
Is “abc” a primitive value?
What restrictions are placed on the values of each case of a switch statement?
what is an isolation level?
How substring() method of string class create memory leaks?
What is prototype?
Do we need to override service() method
What is jboss?
Define aop(assepct oriented programing)?
If your ui seems to freeze periodically, what might be a likely reason?
What is JTS?
Explain the difference between object state and behavior?