Re: [phplib] PHPLib and PostgreSQL (backend still open) From: fabrizio.ermini <email protected>
Date: 04/26/01

On 25 Apr 2001, at 18:40, Konstantin Borchert wrote:

> When i execute a query to the db-server, a connection to postgresql will
> start and i get the
> result what i want. After the query is finished, the backend is still
> open and reserve more than 12MB for

This is not a bug, it's intended behaviour; it's a PHP permanent
connection. Permanent connections are a way to try to minimize
connection overhead, but I agree with you that sometimes they are
detrimental to server workload.

> Can someone help me to modify the phplib, that i can close the backend
> right after i finished the webpage??
> Any ideas??
>

You just have to change 1 row.
Open pgsql.inc (you'll find it in your include dir, if you've installed
PHPlib correctly) and search for the line where the pconnect is
(there is only one in the whole file), then change it to a "normal"
connect. PHPlib will still work as before, and you won't have
anymore lingering pgsql connections.

HTH, bye!

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

Fabrizio Ermini Alternate E-mail:
C.so Umberto, 7 faermini <email protected>
loc. Meleto Valdarno Mail on GSM: (keep it short!)
52020 Cavriglia (AR) faermini <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>