I am writing some code where the database information is run heavy for
a short period of time, and then is "archived", but still in use (just
not at the same capacity). So, for example, I will have a set of data
(about 2500 records) that will be constantly in use (select
statements) for about two months. Currently, that data remains in one
table, I add the next set of records, and the process continues for
the next couple months before I get the next set of data. The data is
constantly growing, but only certain records are being ...