Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
In a local view, what data does VFP move across the network?
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement