Hello all, I used to following test-script to analyze my problems with sleeping-MySQL-pconnects:
Script: <? 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 more. 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]