PHP - 测量HTTP请求的数据库时间

Question

I want to find how much time a PHP http request spends in Database. Rails logger prints out such information (how much time is spent on rendering, database and app). Example:

Completed in 0.01224 (81 reqs/sec) | DB: 0.00044 (3%) | 302 Found [http://localhost/posts]

Is there something similar for PHP too?

Thanks in advance.

Answer 1

You can use microtime() and memory_get_usage() to test the speed as well as the memory used (which is often more important with ORM's).

$time = microtime(TRUE);
$memory = memory_get_usage();

...code here...

print (microtime(TRUE)-$time). ' seconds and '. (memory_get_usage()-$memory). ' bytes';

However, database queries should be benchmarked at the database level. Use MySQL Query Profiler for real benchmarking.