 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / April 2008Pooling of connections
Hi all, I've read a few articles about how pooled connections are more efficient because you don't need to repeatedly setup/teardown a connection - you just acquire connection from the pool. Exactly what steps in setting up/tearing down a connection are skipped by acquiring an already existing connection? Perhaps the steps in establishing/tearing down a connection would help in answering this question? Thanks Taras > Hi all, > [quoted text clipped - 10 lines] > > Taras The process of making a new connection is slow. It requires opening a new socket from the client to the DBMS, which may require the DBMS to spawn a new process, sending connection credentials, which the DBMS must verify and respond to before any real work can be done. A restaurant would be much less practical if it hired a waitress for every new customer and terminated her when she finishes collecting the bill. Joe Weinstein at BEA Systems On Apr 23, 10:41 pm, "joeNOS...@BEA.com" <joe.weinst...@gmail.com> wrote: > The process of making a new connection is slow. It requires opening > a new socket from the client to the DBMS, which may require the DBMS [quoted text clipped - 5 lines] > > Joe Weinstein at BEA Systems So the cost saving is in the setup of a database connection, which includes opening a communication path between the two components (possibly using sockets), and authentication (although I guess that whatever is trying to acquire the database connection would still have to be authenticated)? >On Apr 23, 10:41 pm, "joeNOS...@BEA.com" <joe.weinst...@gmail.com> >wrote: [quoted text clipped - 14 lines] >whatever is trying to acquire the database connection would still have >to be authenticated)? That's pretty much it. Creating the connection involves all that, and is an expensive operation. The connection pool manager acquires the connection and is authenticated, not the consumer of the connection. That authentication is only done once. Eric Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.