Complex Queries: Cycle times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day!
I'm trying to figure out how to cut the cycle time of running a query. Here
is why I THINK I can cut the cycle time, but I'm not sure. I'm just
wondering if anyone has encountered this situation before, and if you think
it is possible:

I'm running Query B off of Query A results. Query A is run from a set of
linked tables. The data for Query A only changes on a daily basis, whereas
Query B's main purpose is to provide a report based upon a single variable.
This process is run 37 times on a particular day, through the use of a macro.
This process currently takes 29 minutes to complete. Here is where I think
a lot of time is wasted:

Since Query B runs off of Query A, every time Query B is run, Query A is
re-run? So, two queries must process before providing a result. Since the
data for Query A only changes on a daily basis, would it speed things up to
export Query A as a table and then run Query B from that specific table?

Thanks for your time and your help!
 
Yes, especially if you then indexed some columns in the new table that
will be used in Query B's criteria (WHERE clause).
 
Back
Top