Thanks for that.
The rub is the 150 simultaneous users, with 50 of them starting an sql query at the same time....

>Hi Glen
>
>Those are not very big tables. Anything under 500,000 records would be considered small for VFP. I have applications with 80 or 90 tables a number of which have 300,000 to 500,000 records accessed over a LAN without a problem. Though the number of users is much less than your application. I usually have 5-6 simultaneous users.
>
>Data corruption in my experience is caused by people shutting down the computer inappropriately or network problems. On a well run network I do not experience corruption or very rarely.
>
>Simon White
>
>
>>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