Re: PHP4 Persistent Connection - Mailing list pgsql-general

From Bruce Momjian
Subject Re: PHP4 Persistent Connection
Date
Msg-id 200102191509.KAA23797@candle.pha.pa.us
Whole thread Raw
In response to PHP4 Persistent Connection  ("Thomas T. Thai" <tom@minnesota.com>)
Responses Re: PHP4 Persistent Connection
List pgsql-general
> should PHP4's persistent connection be used at all? i was going back to
> the mailing list archive and there were discussions about the use of
> persistent connections and interference of one script with another
> in between begin/commits. any clarifications?
>
> was that issue with PHP not reusing persistent connections resolved? i'm
> still seeing this on the Alpha.

The issue is that if you have a script that leaves open a transaction,
the next users gets the in-process transaction.  If all your scripts
close transactions, you are OK.  The new PHP code will close previous
transactions automatically.

We still need to reset any 'SET' commands used, but that can't be done
for 7.1.
--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: PHP4 Persistent Connection
Next
From: Simon Attwell
Date:
Subject: Locking