4600 records is NOT large. There are undoubtedly other factors behind the slow down.
Appropriate indexing on the tables in this database might be the most effective thing you can do. Have you properly indexed the fields on which searches are conducted?
How are searches done?
Are any other functions showing slow performance?
George
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of celestecpa
Sent: Friday, July 15, 2011 1:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Move Data to another Table
I have a split database. The backend is on a server and everyone copies the frontend to their local hard drive.
The main data table has 4600 records in it with at least 100 being added each month.
When the database is queried, it is slow because it is searching all the records.
Some of the records are "closed" are there for reference only.
Would it be wise to take those records out the DataTable 1 and put them in a new table just in case someone needs to see them at a later date?
Looking for suggestions,
Thank you,
Celeste
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar