PHP/MySQL DB Calls are eating my CPU!
Posted 23 February 2006 - 05:41 AM
I have several DB calls, all with proper PHP syntax, in any given page. With only a few users on the site, my processor usage immediately spikes to 99.9%, and the average load is like 62.4, 54.1, 59.0!
This never happend to me using the same scripts with MySQL 3.23 and PHP 4.1
The server is running RHE4, 3.0 GHz P4 and 2 GB RAM. The hosting company is telling me that my DB queries are being pushed out into memory and that is causing the processor to get overloaded. Is this something new in 4.1? Any suggestion?
Posted 23 February 2006 - 11:22 AM
SELECT field1, field2, field3 FROM table
this can use much less cpu & memory
Posted 06 April 2006 - 03:23 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users