I have a complex database on a network that has been in production for 2
years without a hitch (hedges individual loans on a daily basis).  The number
of records (loans) on a daily basis will grow from 500 per day to 10,000 per
day.  

Any recommendations on how to handle this sort of volume.  Clearly
performance takes a serious beating (if it's able to run at all after a
couple of weeks).  

I've been entertaining the idea of creating an archiving routine.  But how
is it helpful to put 10s of thousands of records from one database table to
another?  Any other solutions other than "you can run, but can't hide"

thanks for the help

ps  we will be moving to SQL within the next year, but we need a solution
during the interim.