>>>One thing you can do is to reduce the amount of data fetched over the network. For instance, with parameterized views.
>>
>>Hey I have a question about this.
>>Local parameterized views VS. Remote parameterized views.
>>
>>If you have VFP tables in a .dbc and use remote views to access the data, is that going to generate less network traffic than using the local views? Anyone ever done any testing on this??
>
>The only difference between local and remote views is that remote views use ODBC or OLE DB drivers, in which case they are slower.
>
>Because DBF's are not running in a Server environment, you will not get any difference in network traffic.
>
>Kev

But doesnt a local view acutally require that the table be opened and remain open while the local view has it...?... unlike a remote view where this isn't necessary?