I have a VFP 6 file-server app that uses parameterized local views to access VFP tables. The EXE resides on a workstation and the DBFs reside on a server. I'm trying to troubleshoot some performance problems. I have some questions.
1. When I issue the USE command to open my parameterized view, exactly what portion of the table/index is transferred over the network from the server to the workstation?
2. When I issue a requery() after changing my view's parameter, does the entire table transfer from the server to the workstation, or just the one record I'm requesting? I would think that since this app is not client-server, the entire table would have to transfer each time.
3. When I issue a tableupdate(), does the entire table transfer back to the server or just the records that I have updated? Since there is no intelligent app on the server, how does VFP manage this update?
Thanks,
John