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
