Our manufacturing enviroment demands a high degree of tracebility, therefore we must maintain large amounts of historical data. Our current database size for the Item Master is approaching 2 million records. If we explode our Bill of Materials to the level of 150 parts per Work Order, we could be approaching 1.5 to 2 million records per year.

Currently, all historical data is maintained in one master file for ease of accesss. It's kind'va shotgun approach, but purging historical data offline would seem to be cumbersome.

I've read the general Foxpro reviews on the Chunnel project and the database design seems to handle huge volumes, at what level of maintenance and what degree the software logic is written in seems to be the crux of the issue.

Thanks for the feedback,

Ian