> Perhaps others can respond to how they deal with that
> many records.

I index 6+ years of mail list archives, and I have three indexes:
everything up through the start of this year (rebuilt yearly);
everything from the start of the year until last week (rebuilt weekly);
and everything since Sunday (rebuilt every 15 minutes).  It works out
pretty well.

/jordan