Hi jde, this sounds very strange.
Please post send the results of an traceroute and ping to the list. Perhaps, the bandwidth could be the problem. We have a constellation like you with our boxes in germany. The webservers are located in karslruhe, the mysql-boxes in frankfurt. Everything works fine... Regards, Sebastian jde said: > Greetings, > > I have search the archives over the last two years and have not found > any help for this question. > > The basic setup: An apache/php server exists on the west coast of the > US, and a linux/mysql server on the east coast. > > My PHP snippet looks like this: > > $result = mysql_query("select acolumn from atable where bcolumn=0", $db); > while ($row = mysql_fetch_assoc($result)) echo 'some stuff from the row'; > > > The problem is, that the above snippet, to return seven rows, takes > about 15 seconds. Putting timing statements around the query and around > the fetch calls shows that the query call takes only 0.03 seconds. > However, each fetch call takes anywhere from 0.5 to 5 seconds each to > complete. > > However, if I am logged onto the apacher server and from the user prompt > run the 'mysql' client, and perform the same exact query, the 'mysql' > client can peform the query and return all the results, all 7 rows, in > 0.1 second. > > This is apache 1.3/php 4.3.4 and mysql 4.0.17-standard. > > I have tried all the mysql_connect flags without any change. > > Should I expect such a performance difference? Is there something else I > need to look for? > > Thank you for your time, > jde > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Sebastian Mangelkramer IMAC - Information & Management Consulting Blarerstraße 56, D-78462 Konstanz Tel. +49 (0)7531 - 90 39-11 Fax +49 (0)7531 - 90 39-47 E-Mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php