Sometimes when we do a large load of data the system grinds to a halt until we rebuild the database
Just a thought, do you drop the indexes prior to a large load of data and then rebuild same indexes afterwards?
It could be the updating on the indexes during the large data load that causes some (if not all) of your slowdown.
---------------------------------------------
If data can screw you, it will; never assume the data are correct.