He;lp, Need Performance Improvement Ideas

  • Thread starter Thread starter Henry Smith
  • Start date Start date
H

Henry Smith

Using AC2003 with Win XP.
Have a AC DB with a typical import of 30000 financial records each month.
Have developed a routine/query to extract data to produce a Profit and Loss
report. Because of the large number of records, and maybe the process I am
using, the generation of the report takes too long (10 to 60 seconds).
Looking for performance improvement ideas and techniques for processes that
perform a lot of data gathering and mathematics. Please send ideas and URLs
to any place that has performance improvement ideas and example code.
Thank you for any assistance you can provide.
Cheers,
Henry
 
First thing to check is your indexing.
Indexes on all fields which are sorted or filtered will speed your
performance.
 
Back
Top