Du kan prøve at bruge funktionen BENCHMARK. Nu har jeg bare sakset hvad der står i dokumentationen til MySQL. Den tager tid på dine forespørgsler :)
-----------------------------------------------------------------------
BENCHMARK(count,expr)
The BENCHMARK() function executes the expression expr repeatedly count times. It may be used to time how fast MySQL processes the expression. The result value is always 0. The intended use is in the mysql client, which reports query execution times:
mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));
+----------------------------------------------+
| BENCHMARK(1000000,ENCODE("hello","goodbye")) |
+----------------------------------------------+
| 0 |
+----------------------------------------------+
1 row in set (4.74 sec)
The time reported is elapsed time on the client end, not CPU time on the server end. It may be advisable to execute BENCHMARK() several times, and interpret the result with regard to how heavily loaded the server machine is.
---------------------------------------------------------------------
kilde:
http://webdocs.math.univ-rennes1.fr/MySQL/mysql-3.23.52/manual_Miscellaneous_functions.html/Muddi
