>Robert,
>
>I'm assuming that you are using a VFP database and not a server database like SQL Server. Using VFP data over a WAN can be problematic. The first thing you need to do is make sure that your parameterized views are fully Rushmore optimizable. You should also have your views return as little data as possible. This means limiting both the number of records and the number of fields that are returned.
>
>In order to get really fast performance over a WAN you may need to switch to client/server or use a solution like Citrix WinFrame or MS Terminal Server.
>
>>I coded a program in vfp50 and it uses VIEWS. When I use this program on a WAN, data retrieval is very slow, but it is not slow on the local network. I think the problem is my VIEWS are running from the network drive and not on the user's local computer. Can someone tell me how
>>to get these VIEWS to run on the local computer?
---
also, are you saying that using SQL Server would be faster on
a WAN? :)