Thanks everyone for their input, I am going to try a bunch of options.  Since this is an overnight process that crunches and rebuilds all the data, it's going to take me a week of change and analysis to see what works best.  It's all part of the fun.