Re: PHP4 Persistent Connection

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PHP4 Persistent Connection
Date: 2001-02-19 15:09:54
Message-ID: 200102191509.KAA23797@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergio A. Kessler 2001-02-19 15:34:23 pgPICK or sePICK
Previous Message Mitch Vincent 2001-02-19 14:27:40 Fw: PHP and pg_connect()