Check the description and the comments on 
there is a very good explanation of this problem.

The basic idea is that mysql_pconnect() will not reuse connections opened by different 
httpd processes. If you don't expect more
than 100 concurrent connections stick to the mysql_connect function()

Hope this helps

Dobromir Velev
Web Developer

-----Original Message-----
From: Markus Bruder <[EMAIL PROTECTED]>
Date: Tuesday, December 11, 2001 18:04
Subject: [PHP-DB] problem with pconnect

>Hello all,
>I used to following test-script to analyze my problems with
>require ('database.php');
>$sql = "insert into <tablename> ...";
>$res = query($sql);
>echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"10; URL=<path to script>\">";
>Required file (database.php):
>function query($sql)
> {
>     $hostname = "<databasehostname>";
>     $username = "<databaseusername>";
>     $password = "<databasepassword>";
>     $database  = "<database>";
>     $connect = mysql_pconnect("$hostname","$username","$password");
>     mysql_select_db("$database",$connect);
>     $result = mysql_query($sql,$connect);
>     return $connect;
> }
>The first browser-connect opens up two processes, which are used every time,
>the script reloads itself (rest of time 'Sleep').
>The second browser-connect opens up two processes, too.
>And so on.
>After ending this browser-connects, the processes are all in state 'Sleep'.
>Next browser-connect doesn't re-use any of this processes - it opens up two
>I thought (according to the php-manual) the pconnect-function would re-use
>existing connections, but it doesn't.
>Does anybody know how to solve this problem?
>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]

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]

Reply via email to