Indexing considerations for "large" Access files
Posted on 2012-04-03
Greetings, wizards all ...
I don't know what Access 2007 considers a "large" table, but I have an app that has a number of related tables, and on a recent visit I noticed those tables are nearing 16,000 records each, representing about 8 years of activity. The tables have about 20 fields each.
Are there special indexing considerations I should be applying to tables of this size? Or does that number of records not even come close to a level at which I should be concerned?
Each of these "large" archiving datasets has a primary index. The index field is populated with a Long Integer generated as an autonumber during the creation of the record in a dedicated input table. After the record is created in the input tables, it's moved to storage in an archive file, indexed on the ID assigned during the initial input.
This is in all likelihood a pretty silly question, but I just want to make sure I'm applying all prudent record handling procedures to guarantee the integrity of the data as it heads into the 20 to 25,000 record range.
Many thanks, my friends...