Posted by DarkPilgrim@gmail.com on 11/05/07 03:36

I'm facing a bizare problem with my LAMP.

For I'm preparing the webserver for one event, I have some simple
tests on the server.
I write a php script in which I run about 3000 queries against mysql
db(loop the same query for 3000 times). The queries are simple, just
select * from some table(this table only has about 100,000 records).
But this script told me it cost about 85 seconds!! I have set Apache,
MySQL and PHP on my own machine where the same script cost less than 1
second.
I can't find any error in php or mysql logs.
Server: Red Hat AS 5, Apache 2.2.3, PHP 5.1.6, MySQL 5.0.22 (these are
buddled with red hat)

Anyone, please help me.

[Back to original message]