The best way to speed up preformance

[Frank Situmorang]

Hello,

I have created the Supplier Invoices Tracking Database which has been going
live for 2 years.

There are 8 users and some complain that it performs slow. There are about
26,000 records now.

The BE is in the server, Should I archive the old records to make it run
faster?


Thanks very much,

Frank

 

[Daniel Pineault]

Here are a few link to review to get you started on the path of ms access
database design principles and ms access database application tunning:

http://www.granite.ab.ca/access/performancefaq.htm
http://www.fmsinc.com/MicrosoftAccess/Performance.html
http://www.blueclaw-db.com/access_consultant_rapid.htm
http://dbageek.blogspot.com/2004/10/microsoft-access-performance.html
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tony Toews [MVP]]

I have created the Supplier Invoices Tracking Database which has been going
live for 2 years.

There are 8 users and some complain that it performs slow. There are about
26,000 records now.

The BE is in the server, Should I archive the old records to make it run
faster?

No. 26K records is puny. I had a client with 900K records in one
table although they were having some performance issues. Archiving
also becomes much more of a pain to deal with the data.

Chances are that you need indexes on various fields you are using for
searching and sequencing. Even indexing a yes/no inactive status
field on a customer record can make a substantial difference in some
queries.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/