Perrin wrote:
== $connection = pg_connect($constr user='$USER' password='$PW');
Actually It should be closed the connection after access finished, like that
pg_close();
== pg_close($connection);
But if the user force to close the web page that means have not close the
connection. I want to ask the connection will be closed by Apache Server automatic ?
or when user closed the web page the connection will be closed at the same time ? If
the connection have not been closed automatic. So the Apache Server will keep the
connect port forever ?
Actually the connection port handle by Apache Server or PHP ?
If you use pg_connect, it will close when the script is finished, like
when the page is to the browser. If you use pg_pconnect, it will stay
open for other pages to use. I am not sure how pg_close affects a
pg_pconnect. As most of the overhead with postgres is in opening the
connection, I use pg_pconnect, and never close it. This improves
performance, but if I want to shutdown, I have to shutdown apache before
I shut down postgres just in case there was some recent activity, and it
hasn't timed out yet.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]