>>>>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?
>>>
>>>View is actually cursor created on temporary drive designated for each user. Normally, if app launched by local executable it will go to C:\Temp (i.e. locally again). You can also use Config.fpw options TMPFILES,etc. to get specific location.
>>>However, your problem may have different origin. If your views retrieve alot of data then WAN will be much slower, paradoxically it will be even slower in comparison with situation where you wouldn't not use views at all.
>>---
>>thanks Ed and it is good to hear from you again.
>>What do folks do when they must use a WAN for data retrieval?
>>What is the norm? :)
>
>WAN is just 'bigger' than LAN so time to retrieve the same amount of records will be bigger. So, WAN implies client-server solution where just small recordsets of data travel between server and clients. However, if you use Rushmore properly, VFP still can work on WAN, but you should pay more attention to data retrieval technique (don't use multi-volume views, use Rushmore, avoid to join multiple tables etc.).
---
ok - I see what you mean. the first thing I do in my program is
CREATE SQL. I make a VIEW from the table. that is way things are
taking long. I guess one needs to learn WAN programming. thanks
for the info, do you have an sample of WAN code? :)