Results 1 to 3 of 3
  1. #1
    mike02 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    245

    Query running Slow


    I have a few queries in my current DB which are running extremely slow, Lots of calculations... now im curious to learn ways of improving speed. does anyone have some techniques they are willing to share of improving performance as the number of records increase?

    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    What are these calculations? I would not think simple calcs of fields would be an issue. Domain aggregate functions, however, can significantly slow performance, as well as calls to custom functions.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mike02 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    245
    I do not think the calculations are complex enough. there are no domain functions, or call functions. Through my diagnosis, it is linking 5 tables into one query and running calcs in it. I have compacted and repaired the DB. and that help speed it up a little bit. My only issue is it takes time now, so in the future as the records continue to multiply it will become slower and slower. I have created a bunch of temp tables to speed that process up. It does take a bit of time to run the append queries. Im curious to see if anyone has a different ways they have tried and become success full in improving performance.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Running Slow. Help?
    By alyon in forum Access
    Replies: 16
    Last Post: 12-21-2012, 08:21 AM
  2. Access running very slow
    By k11ngy in forum Access
    Replies: 1
    Last Post: 10-12-2012, 08:09 AM
  3. Reports running slow
    By kwooten in forum Reports
    Replies: 2
    Last Post: 12-02-2011, 03:29 PM
  4. Query running VERY slow
    By purple_kittykat in forum Queries
    Replies: 4
    Last Post: 07-31-2011, 12:40 AM
  5. Replies: 2
    Last Post: 01-19-2011, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums