Hi mike,
>While I see your reasoning for the remote views, you are probably taking a performance hit versus local views, no?
Why do you think that? My experience is that the remote view is (far) faster than the local view if the local view is using dbfs on a remote drive.
There are also a few tricks to speed up your local views:
1. Don't use the Database! prefix in the FROM and join clauses. It will force VFP to open the table again (on OS level), where as the variant without the Database! prefix will use the already open alias.
2. Be aware that you don't use a lot of SET PATH settings. Under a lot of circumstances VFP will search through all path settings (e.g. opening views) to search for a file. This might take significant time, esspecially on slower networks.
3. Use Filemon from
www.sysinternals.com, to figure out what VFP is dragging accross the network and why. Really this could boost up your performance with local data significantly.
Walter,