[AccessD] Timing Form Open

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Mon Nov 5 08:22:08 CST 2007


Dear List:
 
I have a form which opens very slowly on the clients machine over a network.
So I need to speed up the open.
 
But first I need a benchmark.  I tried capturing the time at the start and
end of the Open event and then displaying a message box with the start, end,
and elapsed times.
 
But after I click OK on the message box there's still more stuff going on.
I see Calculating... in the status at the bottom left which I think
indicates that it's still evaluating the record source.
 
And I think the slowness is from the recordsource query and/or the row
sources of the combo boxes.
 
So I need to capture the elapsed time from the very beginning to the very
end of the open and load process.
 
The start time is trivial, I think - first statement in the Open event
timStart = Now.  But where to I capture the stop time?
 
If I can get the real elapsed time then I can begin to tweak the record and
row sources - add indexes, simplify, etc.  But I need an accurate measure of
elapsed time.
 
MTIA
 
Rocky
 



More information about the AccessD mailing list