Roughly how many records would need to be present in a table before you would considder archiving some of that data?
I have a current process that inserts data into about 5 different tables. Most of the tables have < 300K records, but there is one table with over 1 million records. The over all process takes anywhere from 5 minutes to 3 hours to run (regaurdless of the number of records being loaded).
I'm currently running some SQL traces to see exactly what step is taking the longest (probably some locking issue), but I thought I'd ask about the archiving anyway.