Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #14

Re: Pooling of connection

Show all headers | View raw

  To: comp.lang.java.databases
On Apr 22, 11:49 pm, Taras_96 <taras...@gmail.com> wrote:
> 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

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

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar | Unroll thread

Thread

Re: Pooling of connection joeNOSPAM@BEA.com.remove-dii-this - 2011-04-27 15:21 +0000

csiph-web