Hi,
I want to check query execution time.
I used microtime(),time() but not getting accurate result.
I also read about mysql slow_query_log but not able to find how to change settings in PHPmyadmin.
Need suggestions

moehhammadfaizalpratama commented: dsd +0

Recommended Answers

All 3 Replies

If your MySQL server is on a (shared) webhost, you may not have permissions to change any settings. Contact your host.

Timing from a PHP script is inaccurate, because it will include the time of data transfer (very variable).

Thanks pritaeas,
I am using shared webhost.
Is there any (accurate)method to find out query execution time.??

You can try EXPLAIN, but it's resolution isn't high (1/100 secs).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.