Hello,
I'm using a PHP API with MySql.
I can use the mysql_num_rows() function to find out the number of rows in the resultset.
But does anyone know of a way to find out the number of seconds it took to execute a particular query using PHP?
Why I need this is because, I would like to execute the BENCHMARK() function using PHP, but there is not point to this, as I am not able to figure out the number of seconds it took.
BENCHMARK() returns 0, always. The way to use it is to check the time before issuing your query, issue the query, and check the time after the query finishes. Then take the difference between the two times.
This is how the mysql program asesses query times.
Thanks.
-- [ Rajesh Kumar ] __________________________________________ Meet the guy at http://www.meetRajesh.com/
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
