Hi John,
I don't know of any whitepapers on the subject, but for the purposes of securing your data against corruption and whatnot you might want to consider moving to SQL Server. That's a helluva lot of records to be keeping in DBF format. Moving to SQL Server may cost you some speed, but it'll greatly enhance security.
>We are currently in a lull with our development cycle, so I have been given the task of comparing VFP to SQL. We have about 40 tables that get regular use and then another 150 tables for whatever. Our main tables have about 1,000,000 records in them and about 500mb in size. Some in the IS dept. have said that we could triple our data and still be alright. Others think we should upgrade to something like SQL or Oracle. I have been trying to find some stats or performance info to justify staying with FoxPro or to move to a differnet backend. Does anyone know of someplace I can look for the data. If we need to migrate our data, I would rather do it while we have the time instead of when it breaks down. TIA.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05