Timing Database Performance
Posted on 2000-03-29
I'm doing a bit of performance testing to compare inline SQL with stored procs. I need a way to time the execution of the stored proc from VB. The timer control is a pain in the ass - what's the easiest way to do this (down to the millisecond if poss, thousandths will probably do).
All I want to do is call a sub to start and stop the timer, e.g.
set rsResults = BusinessObject.getResults
lngTime = StopTimer
Something like that would be cool.