Timer: Difference between revisions
Jump to navigation
Jump to search
(→Java) |
(+dos) |
||
| 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 29: | Line 29: | ||
# expected result: | # expected result: | ||
# Elapsed time 00h:00m:02s | # Elapsed time 00h:00m:02s | ||
</pre> | |||
== Windows command (DOS) == | |||
<pre> | |||
# show the start time | |||
prompt $d $t $_$P$G | |||
# do something | |||
# 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> | |||
# recode the start time | |||
set startTime=%time% | |||
# do something | |||
# show the start and finish time | |||
echo Start Time: %startTime% | |||
echo Finish Time: %time% | |||
</pre> | </pre> | ||
Revision as of 23:06, 4 April 2018
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, macOS 
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)
# show the start time prompt $d $t $_$P$G # do something # show the finish time prompt $d $t $_$P$G
# recode the start time set startTime=%time% # do something # show the start and finish time echo Start Time: %startTime% echo Finish Time: %time%
Python
performance - Measure time elapsed in Python? - Stack Overflow
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