So, if I were to need to retrieve a single record, and it sits on another machine, how would I do it?
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
>>
>Foxpro doesn't work this way. Actually, each machine works with local data buffers and never transfer whole data for one record retrieval.
Joseph C. Kempel
Systems Analyst/Programmer
JNC