Evaluate execution time

Q

QB

I need to evaluate the time a procedure takes to run so that I can compare 2
procedures... I was wondering if there was any advice on how it should be
done.

My initial idea was to simply create 2 variables: startime & endtime and
place the startime at the very beginning and the endtime at the very end and
equate them equal to time(). Finally end the procedure by debug.print
endtime-startime. Does this make sence? Is there another approach I am
missing? Perhaps a tool already exists to do this type of thing that I am
not aware of?

Thank you

QB
 
M

Marshall Barton

QB said:
I need to evaluate the time a procedure takes to run so that I can compare 2
procedures... I was wondering if there was any advice on how it should be
done.

My initial idea was to simply create 2 variables: startime & endtime and
place the startime at the very beginning and the endtime at the very end and
equate them equal to time(). Finally end the procedure by debug.print
endtime-startime. Does this make sence? Is there another approach I am
missing? Perhaps a tool already exists to do this type of thing that I am
not aware of?

If you only need to time things in seconds, that's fine.
The API can get down to the millisecond
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top