Does anyone know if there is any way to get a high precision (think
microseconds) time from within a sproc? I'd like to time a few of my
sprocs to get a better idea of how they are performing. Something like
this...

get start_time
do some sql magic here
get end_time

time_diff = end_time - start_time

Is this possible with MySQL? If so, would you be able to provide an
example? (I'm really new to MySQL and DBs in general so any additional
information you have would be greatly appreciated.)

Thanks!!!!

On Dec 3, 5:11*am, fuglyducky <fuglydu... (AT) gmail (DOT) com> wrote:
I should add that I tried to use (SELECT DATE_FORMAT(NOW(),'%s.%f'));
but the output is always x.000000.