RE: [PHP-DB] unexplained delay between db connection and db write operations

So you have local code executing against a remote server? And you have the proper accounts and authentication, and direct acccess to the machine? Could this be an issue where users/aapilcations are still locking the old table before the drop command is issued? What is the current load on the machine? users/queries? What happens if you change the name of the table to something else? Is there still the delay? What mechanism are you using to connect? PHP or another scripting language? Java or other compiled language? Some remote system admin tool like 'phpmyadmin' or 'mysqlcc'? Bastien

From: "keith brickey" <k31thb@yahoo.com> Reply-To: "keith brickey" <k31thb@yahoo.com> To: php-db@lists.php.net Subject: [PHP-DB] unexplained delay between db connection and db write operations Date: Sun, 17 Oct 2004 10:57:51 -0700 A php script that creates tables exhibits a 3 minute delay when invoked over the Internet that is not evidenced when invoked using the ISP account where the server resides. A timer function records elapsed time for each operation and reports the elapsed times at the end of the script. The following elapsed times occured when the script was invoked over the internet: seconds to connect & select: 0.00050687789916992 dropped biodata table seconds to make biodata table: 189.00175213814 These are the elapsed times when the script was invoked using the ISP where the server resides: seconds to connect & select: 0.00054097175598145 dropped biodata table seconds to make biodata table: 0.0022339820861816 When invoked over the internet (using a provider other than the one that hosts the web site) there is 189 seconds of additional delay between making the dababase connection and creating the first table. The ISP has other PHP customers who do no experience the problem. I thought the delay may be caused by caching, so I added the following code to the start of the script; however it makes no difference. Furthermore, the delay is about he same regardless of which ISP the browser is using to connect. <?php header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: no-store, no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); header("Cache-control: private"); ?> I will greatly appreciate any suggestions. Thanks, Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php