Postgres Pro
Downloads
Home   >   mailing lists

Thread: PHP4 Persistent Connection

PHP4 Persistent Connection

From
"Thomas T. Thai"
Date:
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.

Re: PHP4 Persistent Connection

From
Bruce Momjian
Date:
> 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

Re: PHP4 Persistent Connection

From
Lincoln Yeoh
Date:
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.

Re: PHP4 Persistent Connection

From
Bruce Momjian
Date:
> 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