Re: Connection pooling in PHP?
- From: Jerry Stuckle <jstucklex@xxxxxxxxxxxxx>
- Date: Thu, 28 Sep 2006 13:33:36 -0400
howachen@xxxxxxxxx wrote:
Hi,
Is that when using pconnect to mysql, it is already mean connection
pooling?
thanks.
No. mysql_pconnect() is a persistent connection. These connections
will be around as long as your web server is running and can be reused
by different scripts. The number of connections is fixed.
Pooling allows connections to be reused also. But the difference is
smart pooling will dynamically adjust the size of the pool. For
instance, if a connect request is issued and there is a free connection,
that one is used. If none are free, a new one is acquired.
When a the application closes a connection, the connection isn't
released immediately. Instead, it can hang around for a while.
Eventually unused connections will be released.
Of course, this assumes one server and one userid/password. It's a
little more complex if you use more than one server and/or
userid/password, but the concept is the same.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.
- References:
- Connection pooling in PHP?
- From: howachen
- Connection pooling in PHP?
- Prev by Date: Re: require_once() driving me MAD ! - please HELP
- Next by Date: Re: Unkowingly Took PHP Job with undgodly PHP Gurus ...
- Previous by thread: Connection pooling in PHP?
- Next by thread: installation frameworks for php
- Index(es):
Relevant Pages
|
