we track by order number, group by loads and subset by products per load. The tables run at around 8 million records each for any given month with the audit trail hitting 30million+ per month.
dont be shy, just get damn good hardware , lots and lots of ram and multithreading processors.
______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.