Hi all,

I have a question regarding VFP's performance across a local area network as to how it handles data transfer between the client and server computers.

In our case, we have a 501 MB (2,000,000+ rows) table sitting on a server. Our application does not open the table directly but uses a local parameterized view to extract data.

My question is: When our application issues a tableupdate() in optimistic row-buffering mode, I know VFP opens the base table and the corresponding CDX file, does VFP 'gets' the base table data with the index to the client machine to issue the update? Is the entire base table with CDX 'transferred' across the network?

Any feedbacks, comments or links highly appreciated.