Try putting a separate network connection between your webserver box and your db, specifically for data between PHP and your DB.
Don't route that traffic through the same network as you are using to retrieve the webpage, as the DB connection will eat up all of your bandwidth, leaving none avail
Aha!!!
In preparing to give more info, as requested by Sebastian, I have
discovered that:
You are right, but not exactly for the reasons you describe.
The problem is the fact that I was interleaving the mysql_fetch with
echo. However, I do not believe it is simply an 'adding the latency'.
Th
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 f
There are couple of things that look like they may be slowing you down.
The first one being the east coast/west coast thing. There's a big
possibility for latency issues going that distance no matter how fast
your connection is. You can do a quick test using ping.
You're also writing out to "sc
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 acol
