Re: Persistent connections in PHP - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Persistent connections in PHP
Date
Msg-id dcc563d10708130735m31f175adre05148c0842d1936@mail.gmail.com
Whole thread Raw
In response to Persistent connections in PHP  (Naz Gassiep <naz@mira.net>)
Responses Re: Persistent connections in PHP  (Erik Jones <erik@myemma.com>)
List pgsql-general
On 8/13/07, Naz Gassiep <naz@mira.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.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: copy command - date
Next
From: Michael Fuhr
Date:
Subject: Re: Selecting rows where timestamp between two timestamps