Running a T7200 Dual core processor at 2GHz under XP Pro SP3 and Access 2K3 SP3 ... one table with 200K records where the primary key is a compond of the first 3 fields
Each of these fields is indexed and can be duplicated as long as the combination of the 3 fields is unique ... 2 of these fields have many to 1 relations to 6 other tables (5 tables to 1 field and an information table to the other field)
I went to add 15K of potentially new records to this table ... in the process I used an ADO findfirst statement just to ensure the record didn't exist. This process took over 2 hours to complete ... The findfirst statement uses the first 3 fields in top down order
I then ran the process again and it only took 15 minutes to complete (this time I assume because all the records existed)
Am I missing some basic concept? What is slowing down this process? Index? Related tables? Other?
Both times, 15 minutes to find and 2+ hrs to add 15K of records seems out of line especially since these are indexed?
Each of these fields is indexed and can be duplicated as long as the combination of the 3 fields is unique ... 2 of these fields have many to 1 relations to 6 other tables (5 tables to 1 field and an information table to the other field)
I went to add 15K of potentially new records to this table ... in the process I used an ADO findfirst statement just to ensure the record didn't exist. This process took over 2 hours to complete ... The findfirst statement uses the first 3 fields in top down order
I then ran the process again and it only took 15 minutes to complete (this time I assume because all the records existed)
Am I missing some basic concept? What is slowing down this process? Index? Related tables? Other?
Both times, 15 minutes to find and 2+ hrs to add 15K of records seems out of line especially since these are indexed?