Idea's on seeding up a report/query RRS feed

  • General discussion

  • I am using a query that contains 3 union-ed queries. This pulls roughly 165,000 + records. This alone takes about 10 seconds at most. However, I'm filtering that data upon things which has to do a calculation of up to 10 times on each one of those records. This ends up making it extremely slow.

    What are some good practices to speed up a report that will make it much faster?

    I'm not able to give the exact query or the exact data.

    Dim Blondedude092 as SkypeUser

    Thursday, March 31, 2016 11:27 PM

All replies

  • Is a network involved?

    If yes, then run the one query to a local temp table, and process on that – you see fantastic speed.


    Albert D. Kallal (Access MVP)

    Edmonton, Alberta Canada

    Saturday, April 2, 2016 9:43 PM
  • Apply the WHERE to each of the quries before the UNION.
    Saturday, April 2, 2016 9:45 PM
  • Hi Dim -

    You really can’t speed up a process; it takes whatever time is necessary. Therefore, to spend less time, you must have the computer do less work. To do that, YOU must do more work figuring that out. Whose time is more valuable: yours, or the computer’s? How many times are you going to perform this process? What are you using to measure time? Does the report have to be complete, or can you deliver a page at a time? Bon voyage! ;o)

    peter n roth - http://PNR1.com, Maybe some useful stuff

    Sunday, April 3, 2016 6:51 PM
  • Just tossing this out there, since you are unable to post your exact query. 

    Query/Report Performance Tips  (Look specifically under the Query and Report headings)

    Despite the article's '2007' title, these tips apply universally.


    Miriam Bizup Access MVP

    • Edited by mbizup MVP Monday, April 4, 2016 9:30 AM
    Monday, April 4, 2016 9:27 AM
  • Miriam - Thx for the link!

    peter n roth - http://PNR1.com, Maybe some useful stuff

    Monday, April 4, 2016 7:52 PM
  • Great source. Thanks, Miriam!

    Bill Mosca

    Monday, April 4, 2016 8:23 PM