S
SillyGoose
Hi. I am trying to resolve an interesting gperformance
issue regarding the opening of either a table or a query
via as a recordset using the DAO method.
I have written a timing function to determine how long it
takes to open and close a recordset using a variety of
permutations --- snapshot, dynaset, read-only, etc.
The timing function starts the timer, opens the recordset,
closes the recordset, and stops the timer.
If I call the timing function twice in succession in
precisely the same way, the first time it runs it takes
significantly longer in order of magnitude --- for
example, .35 seconds compared to .01 seconds. This
happens for tables or queries, and in all permutations.
Therefore, the general question is this: why does it take
longer to open the recordset the first time only ?
Thank you for your consideration.
Rodney M. Gabriel
issue regarding the opening of either a table or a query
via as a recordset using the DAO method.
I have written a timing function to determine how long it
takes to open and close a recordset using a variety of
permutations --- snapshot, dynaset, read-only, etc.
The timing function starts the timer, opens the recordset,
closes the recordset, and stops the timer.
If I call the timing function twice in succession in
precisely the same way, the first time it runs it takes
significantly longer in order of magnitude --- for
example, .35 seconds compared to .01 seconds. This
happens for tables or queries, and in all permutations.
Therefore, the general question is this: why does it take
longer to open the recordset the first time only ?
Thank you for your consideration.
Rodney M. Gabriel