Re: Optimizing a Stored Procedure

[Rick James]

> MySQL 6.3.0.642
No such version of the server.

SELECT @start := NOW();
...
51client> SELECT TIMEDIFF(NOW(), @start);
+-------------------------+
| TIMEDIFF(NOW(), @start) |
+-------------------------+
| 00:00:15                |
+-------------------------+

But that is resolution only to the second. For higher resolution, use PHP's microtime or Perl's Time::HiRes or ...