[AccessD] List Boxes

Tony Septav iggy at nanaimo.ark.com
Sun Dec 19 10:05:16 CST 2010


Hey All
Not a biggy, just would like to know out of curiosity.
I put a timer on my continuous forms to see how long it takes for the 9 
queries to fire. Was trying to figure out what query was taking longer 
then the others, so maybe I could approach it a different way and 
increase the speed (many of the queries involve a set of sub queries). 
What I found was interesting.  When clicking on a specific record I 
could get several different times to run all 9 queries and the times 
were random  when running a the queries
Times to complete in seconds
0.9999999997205
1.000000008
1.9999999998001
2.0000000016
I didn't matter what record I chose in the list I could get anyone of 
the various times recorded above to run all 9 queries.  Does anyone know 
what would cause this???




More information about the AccessD mailing list