Just my two cents: When working with large files on a network, there is no way to get around the performance problems other than going to client/server. Your design could be the best possible, but if the files are large enough, you are in trouble.

Joe

>>We have a VFP application running on NT LAN. Sometimes it's slow, especially while working with big tables.
>>How large are changes necessary for migration to C/S technology with
>>SQL-server ?
>>TIA
>
>I am no expert in C/S but I suspect the performance problems you are seeing may be related more to the design of the application than to whether or not it's using DBF's or SQL Server.
>
>For some real insight into client-server issues go find the thread entitled "VFP best front end?" which is currently running in the Client-Server section here on UT. Some very knowledgeable people with real-world experiences are weighing in on this one.
>
>HTH,
>Rick