>A client wants to run a VFP system with
>Three Tables...
> Customer table up to 50,000 records
> Person table, linked to above, up to 300,000 records
> Order Form Table, linked to Customer, up to 700,000 records
>
>Under LAN I am afraid of data corruption and speed issues, as the software does many different queries that are not indexed.
>
>Under SQL I am not concerned with data corruption, but am still concerned with speed, especially if 30 people query the Order Form Table simultaneously.
>
>Has anyone ever dealt with tables these sizes and this many users. ALL input would be helpful.
>
>Thanks,
>Glenn

I have a client with a database directory (VFP database) that is 9gb... the biggest table (.dbf) has 6million records and is 1gb in size. There are other files approaching 1gb with 1million records as well. There are 200-250 people in this system all day.