by "joeNOSPAM@[EMAIL PROTECTED]
" <joe.weinstein@[EMAIL PROTECTED]
>
Apr 23, 2008 at 07:41 AM
On Apr 22, 11:49 pm, Taras_96 <taras...@[EMAIL PROTECTED]
> 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
> establi****ng/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
