Timer: Difference between revisions
Jump to navigation
Jump to search
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
Get the execution time of the script or sql query | Get the execution time of the script or sql query. | ||
== PHP == | == PHP == | ||
[http://stackoverflow.com/questions/8310487/start-and-stop-a-timer-php Start and stop a timer PHP - Stack Overflow] | * [http://stackoverflow.com/questions/8310487/start-and-stop-a-timer-php Start and stop a timer PHP - Stack Overflow] | ||
* [http://stackoverflow.com/questions/6245971/accurate-way-to-measure-execution-times-of-php-scripts Accurate way to measure execution times of php scripts - Stack Overflow] | |||
== MySQL == | == MySQL == | ||
Line 10: | Line 10: | ||
SELECT @timer := CURRENT_TIMESTAMP(); | SELECT @timer := CURRENT_TIMESTAMP(); | ||
SELECT SLEEP(2); /* sleep 2 seconds for testing purpose */ | SELECT SLEEP(2); /* sleep 2 seconds for testing purpose */ | ||
SELECT 'custom message' AS 'action', CURRENT_TIMESTAMP() AS ' | SELECT 'custom message' AS 'action', CURRENT_TIMESTAMP() AS 'finish time', @timer AS 'start time', TIMEDIFF(CURRENT_TIMESTAMP(), @timer) AS 'time elapsed'; | ||
</pre> | </pre> | ||
Line 16: | Line 16: | ||
{{Linux}} console, {{Mac}} Terminal or Cygwin commands on {{Win}}<ref>[http://stackoverflow.com/questions/385408/get-program-execution-time-in-the-shell linux - Get program execution time in the shell - Stack Overflow]</ref><ref>[http://stackoverflow.com/questions/12199631/convert-seconds-to-hours-minutes-seconds bash - Convert seconds to hours, minutes, seconds - Stack Overflow]</ref> | {{Linux}} console, {{Mac}} Terminal or Cygwin commands on {{Win}}<ref>[http://stackoverflow.com/questions/385408/get-program-execution-time-in-the-shell linux - Get program execution time in the shell - Stack Overflow]</ref><ref>[http://stackoverflow.com/questions/12199631/convert-seconds-to-hours-minutes-seconds bash - Convert seconds to hours, minutes, seconds - Stack Overflow]</ref> | ||
<pre> | <pre> | ||
# start the timer | |||
START=$(date +%s) | START=$(date +%s) | ||
Line 21: | Line 22: | ||
sleep 2s | sleep 2s | ||
# stop the timer | |||
END=$(date +%s) | END=$(date +%s) | ||
DIFF=$(( $END - $START )) | DIFF=$(( $END - $START )) | ||
printf | printf "Elapsed time %02dh:%02dm:%02ds\n" $(($DIFF/3600)) $(($DIFF%3600/60)) $(($DIFF%60)) | ||
# expected result: | |||
# Elapsed time 00h:00m:02s | |||
</pre> | |||
== Windows command (DOS) == | |||
<pre> | |||
REM show the start time | |||
prompt $d $t $_$P$G | |||
REM do something ... | |||
REM show the finish time | |||
prompt $d $t $_$P$G | |||
</pre> | |||
or ...<ref>[https://stackoverflow.com/questions/673523/how-do-i-measure-execution-time-of-a-command-on-the-windows-command-line batch file - How do I measure execution time of a command on the Windows command line? - Stack Overflow]</ref><ref>[https://stackoverflow.com/questions/166044/sleeping-in-a-batch-file python - Sleeping in a batch file - Stack Overflow]</ref> | |||
<pre> | |||
REM start to record the start time | |||
set startTime=%time% | |||
REM do something ... | |||
REM show the start and finish time | |||
echo Start Time: %startTime% | |||
echo Finish Time: %time% | |||
</pre> | </pre> | ||
== Python == | == Python == | ||
[http://stackoverflow.com/questions/7370801/measure-time-elapsed-in-python performance - Measure time elapsed in Python? - Stack Overflow] | Using [https://docs.python.org/3/library/time.html#time.time time.time()]<ref>[http://stackoverflow.com/questions/7370801/measure-time-elapsed-in-python performance - Measure time elapsed in Python? - Stack Overflow]</ref> | ||
<pre> | |||
import time | |||
# start the timer | |||
start = time.time() | |||
# do something | |||
# stop the timer | |||
end = time.time() | |||
print("Elapsed time in seconds: ", end - start) | |||
</pre> | |||
== Java == | |||
[https://docs.oracle.com/javase/7/docs/api/java/lang/System.html#currentTimeMillis() Java.lang.System.currentTimeMillis()] | |||
<pre> | |||
# start the timer | |||
long start_time = System.currentTimeMillis(); | |||
# stop the timer | |||
System.out.println("\nElapsed time: " + (System.currentTimeMillis() - start_time) + " ms"); | |||
</pre> | |||
References | References | ||
Line 36: | Line 84: | ||
<References /> | <References /> | ||
[[Category:Programming]] [[Category:PHP]] [[Category:MySQL]] [[Category:Tool]] | [[Category:Programming]] [[Category:PHP]] [[Category:MySQL]] [[Category:Java]] [[Category:Python]] [[Category:Bash]] [[Category:Tool]] |
Revision as of 10:10, 9 September 2020
Get the execution time of the script or sql query.
PHP
- Start and stop a timer PHP - Stack Overflow
- Accurate way to measure execution times of php scripts - Stack Overflow
MySQL
Recording the time elapsed after the sql query was executed.
SELECT @timer := CURRENT_TIMESTAMP(); SELECT SLEEP(2); /* sleep 2 seconds for testing purpose */ SELECT 'custom message' AS 'action', CURRENT_TIMESTAMP() AS 'finish time', @timer AS 'start time', TIMEDIFF(CURRENT_TIMESTAMP(), @timer) AS 'time elapsed';
Linux command (BASH)
Linux console, Mac Terminal or Cygwin commands on Win [1][2]
# start the timer START=$(date +%s) # sleep 2 seconds for testing purpose sleep 2s # stop the timer END=$(date +%s) DIFF=$(( $END - $START )) printf "Elapsed time %02dh:%02dm:%02ds\n" $(($DIFF/3600)) $(($DIFF%3600/60)) $(($DIFF%60)) # expected result: # Elapsed time 00h:00m:02s
Windows command (DOS)
REM show the start time prompt $d $t $_$P$G REM do something ... REM show the finish time prompt $d $t $_$P$G
REM start to record the start time set startTime=%time% REM do something ... REM show the start and finish time echo Start Time: %startTime% echo Finish Time: %time%
Python
Using time.time()[5]
import time # start the timer start = time.time() # do something # stop the timer end = time.time() print("Elapsed time in seconds: ", end - start)
Java
Java.lang.System.currentTimeMillis()
# start the timer long start_time = System.currentTimeMillis(); # stop the timer System.out.println("\nElapsed time: " + (System.currentTimeMillis() - start_time) + " ms");
References
- ↑ linux - Get program execution time in the shell - Stack Overflow
- ↑ bash - Convert seconds to hours, minutes, seconds - Stack Overflow
- ↑ batch file - How do I measure execution time of a command on the Windows command line? - Stack Overflow
- ↑ python - Sleeping in a batch file - Stack Overflow
- ↑ performance - Measure time elapsed in Python? - Stack Overflow