Why and when do we use connection pool management system instead of database?

Questions by kiranmaye

Showing Answers 1 - 18 of 18 Answers

fcasttro

  • Nov 21st, 2007
 

Connection Pool Management reuses the active database connection. The connection pool manager maintains a pool of database connections.When we need our apllication to be work fast.we can go for pooling..

  Was this answer useful?  Yes

ayash81

  • Dec 24th, 2007
 

Connection pool allows the reusability of the connenction. It can be borrowed from the pool then can be used & can be closed when necessary. The connection pool manager manages all the connections in a pool.

  Was this answer useful?  Yes

achyut

  • Jan 28th, 2008
 

When multiple user access the database that time we ll go for connection pool. It supports more than one user at a time. The main advantage is it can be used in distributed application.

  Was this answer useful?  Yes

sampra

  • Feb 19th, 2008
 

There is so many reason why we are using connection pooling rather than database beacuse if we need more connection then container can create more connection and if connections are not in use then container can destroy the conncection.  Mainly we are taking connection to connect the database..

  Was this answer useful?  Yes

Connection Pooling is like u have created a set of connection pools and hav stored them in some data structure.The benefit which u get by doing this is everytime u get a new request u can use one of the available connections u don need to establish a new connection everytime a requests comes up.This enhances the performance of ur servlet and makes it faster.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions