Re: Persistent connections in PHP

On 8/13/07, Naz Gassiep <naz(at)mira(dot)net> wrote:
> Hi,
> Does the connection pooling feature of PHP cause the persistent
> connections to keep the properties between accesses? E.g., if a user
> takes a connection, sets a timezone to it using SET TIMEZONE, will the
> next user who happens to take this connection get it in that same state,
> or will it be reset to a blank or starting state as though it had been
> opened? Also, what about temp tables? Will they be present to the second
> user if the first user set some up?

Except for a few special uses, persistent connections in php are more
of a misfeature. They are NOT pooling, in the standard sense. Most
of the time they cause more problems than they solve.