Обсуждение: PHP4 Persistent Connection

Поиск
Список
Период
Сортировка

PHP4 Persistent Connection

От
"Thomas T. Thai"
Дата:
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

От
Bruce Momjian
Дата:
> 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

От
Lincoln Yeoh
Дата:
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

От
Bruce Momjian
Дата:
> 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