Hi Alex, On Apr 8, 2007, at 10:17 AM, Alejandro Decchi wrote:
I need to optimize my Apache and my PHP and Mysql. Now my apache uses 90 % of CPU when i run a query by the apliaction webpage.But when i make the same query by mysql command it is very fastest.Why my apache use 90% of CPU when i run a query by my webpage ?? Someone can help me???
The fact that no one has reacted to your repeatedly asking the same question over the past couple of days usually indicates that no one here truly understands your question, or knows the answer to it.
When you say Apache uses 90% CPU, is that out of the ordinary? I would expect the kernel to grant all available CPU power to a process that has work to do. Are you seeing unacceptable delays in page display when you run your web app?
If I were you, I'd concentrate on the PHP code in your application. Apache by itself is pretty fast, and you have already established that executing the query in MySQL is not the problem (good troubleshooting skill there).
So, that leaves the application code. Could you possibly be doing something inefficient with the data once fetched from the database? Unfortunately, this is not a forum for help with PHP optimization: if you need more help with that please check php.net.
S. -- sctemme@xxxxxxxxxx http://www.temme.net/sander/ Open Source Software Consultant PGP FP: 51B4 8727 466A 0BC3 69F4 B7B8 B2BE BC40 1529 24AF ApacheCon 2007 Europe, May 1-4 in Amsterdam http://www.eu.apachecon.com/
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
|