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");
     $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]

Reply via email to