My mistake...he didn't say "large"...he said "big".

Joe

>Situation:
>
>You need to retrieve a single record from a table across the network. The table and index file uses 500 Mb of disk space. The record is 10K. With VFP, you must transfer all 500Mb over the network, then perform the lookup. With C/S, you have to request the data, then transfer 10K over the network. A 10K transfer is faster than a 500 Mb transfer.
>
>Did the original creator of this thread not say that he was experiencing slow-downs due to large tables?
>
>Joe
>
>>>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
>>
>>Joe, what does it mean large? You can have millions of records and stellar VFP performance. The real difference is how the data used interactively, i.e. how often users create/edit records.