MYSQL
(quick guide & examples)
OPEN COMMAND LINE & RUN MYSQL mysql --user USER --password PASS --database DB
RUN SQL QUERY SELECT INSERT REPLACE UPDATE DELETE
RESULTS WILL SHOW "TIME TAKEN"
ENABLE PROFILING SET profiling = 1;
RUN SQL QUERIES SELECT INSERT REPLACE UPDATE DELETE
SHOW PROFILES SHOW PROFILES;
BENCHMARK(LOOP, STATEMENT) FOR EXAMPLE, RUN 1+1 FOR 1000 TIMES BENCHMARK(1000, 1+1)
$runs = 1000; $start = microtime(true); $stmt = $pdo->prepare(SQL); for ($i=0; $i<$runs; $i++) { $stmt->execute(); } $end = microtime(true); $taken = $end - $start;