>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.
Edward Pikman
Independent Consultant