% PHP vs % MySQL in Micro Stats
 

Ok.. I like the hack. Great hack, but I'm curious to see how my numbers stack up and what if anything would be wrong. The numbers seem strange to me (but then again), I don't know what they mean fully.. Guess I should start with that.

vbPortal Front Page :
0.4795480 seconds (87.41% PHP - 12.59% MySQL)

Forums Front Page :
0.1290790 seconds (77.19% PHP - 22.81% MySQL)

Is it better to have higher PHP % or MySQL %? Does it matter?

Thanks

Josh

i believe that it is better to have a higher PHP one as the script will then need to run more queries if there is more MySQL ones and it will slow the loading of the page ;)

Yeah, this is something I'm trying to figure out as well, I've had as high as 94% PHP and 6% MySQL, but no definitive answer yet.

Your explanation does make sense though

Thanks

Josh

The percent is calculated by the time spent to execute the script - time to do queries ?

What really matters is the total time the page takes to execute...

Here's how I use it for www.computergames.ro

$time = round (($time_end - $time_start), 4);

$time_q = round($db->get_query_time(), 4); // time MySQL

$time_p = $time - $time_q; // time PHP

$percentage_q = round($time_q * (100/$time), 2);
$percentage_p = round($time_p * (100/$time), 2);

i'm romanian to... :)