timing a script

[OwenTheSamoan]

Using php with mysql. I'm using a few different types of select statments in my scripts and I was wondering if there was a way that I could get a print of how long it took for each script until it was executed. That way I can compare scripts and see which one is the most efficient. Thanks in advance.

Owen the Samoan

[devinemke]

grab one [man]microtime[/man] before the query and another one after and then compare.

[OwenTheSamoan]

thanks!

[MarkR]

One method is to use Apache to time the request. I use the following:

# %D = microseconds
LogFormat "%h %t \"%r\" %>s %D" time
CustomLog logs/time_log time

Which will create a file in your logs directory called time_log, which logs the total time for each request in microseconds.

Obviously, when trying to time stuff:

• Do it on an otherwise idle machine
• Repeat the test a number of times and take the average or something
• Don't run the web browser on the same machine! The browser and server fight over CPU which distorts results.

So ensure that your test server and test clients are different physical machines, and that your test server is otherwise idle.

Mark

[Roger_Ramjet]

If it's just the speed of your queries you are after then Read This and pay particular attention to the section on EXPLAIN