Timer
Jump to navigation
Jump to search
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 'end 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
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