RE: unexplained delay between db connection and db write operations

"Bastien Koert" <bastien_k@xxxxxxxxxxx> · Sun, 17 Oct 2004 20:43:16 -0400

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@xxxxxxxxx>

Reply-To: "keith brickey" <k31thb@xxxxxxxxx>

To: php-db@xxxxxxxxxxxxx

Subject:  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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php