>>>>My users have been using my EXE (vfp50) on a LAN with the
>>>>data files living on a network drive. Now the users want to use this EXE on a WAN, but still want to keep the data files on the home network drive. After testing the program on a WAN, I find the data retrieval is too slow. I am using VIEWS. What can I do to speed things up?
>>>>
>>>
>>>You should be very careful using views. The difference is that when you open a table, Foxpro will load just few records on workstation, but when you open view Foxpro will retrieve all records pertained to this view, and if you have many records then whole process will be exteremely slow especially on WAN.
>>---
>>hi edward - i can see how this area can be tricky... i have a problem.
>>i coded my program using VIEWS. what about using SET FILTER TO someting in a VIEW? any ideas?
>
>SET FILTER on VIEW will change nothing because firstly Foxpro will collect records in the view and only after this will apply filter. What you should do is to use parameterized views or even rethink the way you develop the interface to either work with tables itself or pick just few records in views.
---
ok - good: could you please give me a small code sample of a parameterized views
and a sample of:pick just few records in views. that would help... :)