PHP4 Persistent Connection

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

At 10:09 AM 19-02-2001 -0500, Bruce Momjian wrote:

We still need to reset any 'SET' commands used, but that can't be done
for 7.1.

Would you have to do an unlisten *?

Are there other per connection things as well?

Cheerio,
Link.

At 10:09 AM 19-02-2001 -0500, Bruce Momjian wrote:

We still need to reset any 'SET' commands used, but that can't be done
for 7.1.

Would you have to do an unlisten *?

Are there other per connection things as well?

Wow, yes, there are probably many things we will need to do to reset the
connection. Removal of temp tables may also be needed.

-- 
  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