Archiving and Access Performance with 1000s of Records

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi, I am creating a database and have a question or two.
I wanted to test the normal queries and summation queries with right sided
joins on a lot of records. In the tables I used, I had between 30,000 and
100,000 and performance was very slow.
I then changed it to between 10,000 and 50,000 and performance is slow.
I improved performance by making queries and matching IDs to
forms!form1!jobid or something. The only problem is that this is most
impractical and a little crude, as I need a separate query per form or
report, even if it's the same query, just with a different parameter.
My main question is really, what's the best way of getting the best
performance when using summation queries (possible right hand join) with
several thousand records and what are the best and easiest methods to
archive records, perhaps to other tables or databases?
Many thanks,
Neil.
 
The easiest way is to create indexes on the table fields that you will be
querying by, grouping by, or ordering by.
 
Back
Top