MySQL query time

ffejy · 8-22-02, 10:55 PM

I know when you run a mysql query from the command line, it returns the table, and it says how long it took to run the query. Is there a function to get this number in PHP?

HalfaBee · 8-22-02, 11:54 PM

I dont think there is you may have to do it manually.

function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}

$time_start = getmicrotime();

mysql_query( "" );

$time_end = getmicrotime();
$time = $time_end - $time_start;

echo "Did nothing in $time seconds";

HalfaBee

ffejy · 8-23-02, 01:25 PM

Thanks HalfaBee! I looked in the manual and didn't see any obvious functions like mysql_get_query_time()

Thanks for that snippet

HalfaBee · 8-24-02, 12:11 AM

Thats Ok its from the php manual.

HalfaBee

ffejy · 8-24-02, 12:18 AM

Well, you found it there... thanks

8-22-02, 10:55 PM	#1
ffejy Endangered Species Join Date: Apr 2002 Location: Massachusetts Posts: 452 Reputation: 5	MySQL query time I know when you run a mysql query from the command line, it returns the table, and it says how long it took to run the query. Is there a function to get this number in PHP? __________________ Jeff Why doesn't DOS ever say "Good command or file name"?

8-22-02, 11:54 PM	#2
HalfaBee Join Date: Feb 2002 Location: Sydney, Australia Posts: 7,266 Reputation: 340	I dont think there is you may have to do it manually. function getmicrotime(){ list($usec, $sec) = explode(" ",microtime()); return ((float)$usec + (float)$sec); } $time_start = getmicrotime(); mysql_query( "" ); $time_end = getmicrotime(); $time = $time_end - $time_start; echo "Did nothing in $time seconds"; HalfaBee __________________ I don't suffer from laziness, I enjoy every minute! Edit your php.ini here http://members.powweb.com/member/cgi...nt/PHPplus.bml

8-23-02, 01:25 PM	#3
ffejy Endangered Species Join Date: Apr 2002 Location: Massachusetts Posts: 452 Reputation: 5	Thanks HalfaBee! I looked in the manual and didn't see any obvious functions like mysql_get_query_time() Thanks for that snippet __________________ Jeff Why doesn't DOS ever say "Good command or file name"?

8-24-02, 12:11 AM	#4
HalfaBee Join Date: Feb 2002 Location: Sydney, Australia Posts: 7,266 Reputation: 340	Thats Ok its from the php manual. HalfaBee __________________ I don't suffer from laziness, I enjoy every minute! Edit your php.ini here http://members.powweb.com/member/cgi...nt/PHPplus.bml

8-24-02, 12:18 AM	#5
ffejy Endangered Species Join Date: Apr 2002 Location: Massachusetts Posts: 452 Reputation: 5	Well, you found it there... thanks __________________ Jeff Why doesn't DOS ever say "Good command or file name"?