> Does sound like an awful lot of data. I think the question might be > reworded to ask is there any manageable logical groups of data that > might lend themselves to simple segmentation into separate > tables/databases?
I thought about asking that as well, but wondered if there wasn't a simpler solution that would make his existing setup work. > > Commercial databases often range into terabytes but I doubt many > accomplish those numbers with a single table. None that I have worked > on ever have, including "never ever forget", (spool or delete) SAP:-) Yeah, I just noticed some of them have support for transparently querying across multiple tables to handle this sort of thing without so much pain!