RE: CPU usage @5% during 2 minutes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-------------- Original message from Janke Dávid : -------------- 

> The sample code (in seperate, this piece of code runs with normal speed, 
> but it is this part which runs slowly when executed as a whole, 
> everything else is fast): 
> 
> 
> $sqlquery = "SELECT sh_Number, sh_Status FROM service_sheet ORDER BY 
> sh_Number DESC"; 
> $result = mysql_query($sqlquery) 
> or die (mysql_error()."

Are you sure it is not the query that is running slow?  Have you looked to see what mysql is doing when the application hangs?  What processes does top show as running and using resources?  Has the mysql config recently changed?  What does an explain on that query show?

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux