Persistent connections are typically a good thing to use on high traffic
sites as they offer better performance than opening and closing connections
for each database request. The reason for this is the overhead used in
opening a database connection is actually quite high.
While keeping them open when they are no longer needed may seem
counter-intuitive, the connection isn't being saved for a particular user
or page, instead it remains open and will automatically be used by any page
requiring database connectivity on your site. If there are no free
connections when a page request comes in, a new one is open. Conversely if
a connection has not been utilized for a specific period of time (usually a
couple minutes) it will be closed.
At 02:46 PM 8/14/2002 +0100, John Wards wrote:
>I am running a website which generates around 100,000 pageviews a day and I
>am wondering if I stop using persistent conections to the database and use
>normal open and close conections this would reduce the load onto my server?
>Most conections are either made through my "main" file or the phorum message
>Thanks in advance
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php