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???