Varying times to run same query

[Guest]

I'm sure this is basic Access knowledge, but I'm hoping there are some tricks
that will help speed up my efficiency.

I have a series of queries that I run frequently. In some instances, the
query takes 2-5 seconds to run. On other day, or in another Access session
on the same day, the query takes 45+ seconds. I don't understand why, and if
there is something I'm doing one time but not the other, then I'd love to
know what it is!

Thanks in advance
Daniel

 

[David F Cox]

A lot of this sort of variation is down to the operating system. It may be
busy doing "its own thing" at the same time. Also applications use code
blocks called dynamic linked libraries (.dll) which are loaded into memory.
In practical terms they are often loaded from the filing system into the
virtual memory, copied from one disk area to another. If a previous program
has used that .dll it may be still in memory, and not need reloading.
Another factor may be that some badly behaved program has taken a lot of
memory, but then failed to release it, so the machine is working with
reduced capability.

In short, that's just the way it is.

 

[Guest]

Thanks David, I appreciate the response

A lot of this sort of variation is down to the operating system. It may be
busy doing "its own thing" at the same time. Also applications use code
blocks called dynamic linked libraries (.dll) which are loaded into memory.
In practical terms they are often loaded from the filing system into the
virtual memory, copied from one disk area to another. If a previous program
has used that .dll it may be still in memory, and not need reloading.
Another factor may be that some badly behaved program has taken a lot of
memory, but then failed to release it, so the machine is working with
reduced capability.

In short, that's just the way it is.