>>>>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 ?
>
>I don't think that your problem lays within Foxpro reach. For example, I maintain high-volume VFP system (millions of records) with database located on WinNT server and clients connected using LAN and WAN, i.e. clients are in different geographic locations. This system uses traditional methods of opening tables, it even doesn't use local views, however it works pretty fast. Fortunately, speed has never been a problem for this system and I didn't bother to speak with our network people how they arrange things.

When you use a table (i.e. Use Employee) why don't you experience a long delay? When I programmed in Fox 2.5 for DOS when opening a large table accross the WAN It would download many more records that required. Is their a way to turn this off in VFP? 'No data on load' didn't seem to work.