>>I did some other testing last night with remote views ? If I had a VFP database across town on a windows NT server connected via 56K WAN link. Could the client app effeciently use a parameterized view of that remote data and avoid the overhead of using the native tables on the LAN. Is this not a slant of client server. Meaning the client software asks the user for the particular employee number and the server across town returns only that employee information which is one record.
>
>This does not happen. The vfp odbc driver is a subset of vfp that accesses vfp tables exactly the same way vfp does. In order to execute a SQL query on a remote foxpro table, the vfp odbc driver opens the tables and indexes, navigates through the tables and indexes until all records matching the where and having conditions are found, the vfp odbc driver then passes the result set to the app.
>
>In true client/server, the odbj driver passes the sql statement to the remote server. The remote server has a task that executes the query and returns a result set. The result set is then transfered through the network to the odbc driver which passes the data set to the app.
Albert,
Do you think the remote Views would work effeciently/effectively for the purposes I have described ?
Scott k
P.S. Edward what are your thoughts ?
Précédent
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