Timer: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
Get the execution time of the script or sql query was executed. | |||
PHP: [http://stackoverflow.com/questions/8310487/start-and-stop-a-timer-php Start and stop a timer PHP - Stack Overflow] | PHP: [http://stackoverflow.com/questions/8310487/start-and-stop-a-timer-php Start and stop a timer PHP - Stack Overflow] | ||
Revision as of 12:32, 8 December 2016
Get the execution time of the script or sql query was executed.
PHP: Start and stop a timer PHP - 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 'end time', @timer AS 'start time', TIMEDIFF(CURRENT_TIMESTAMP(), @timer) AS 'time elapsed';
Linux 
or Cygwin commands on Win 
[1]
START=$(date +%s) sleep 2s END=$(date +%s) DIFF=$(( $END - $START )) echo "Elapsed time $DIFF seconds"
Python: performance - Measure time elapsed in Python? - Stack Overflow
References