>>>Because i've had the same problems with a application working with data on a WAN I applied the following:
>>>
>>>Where ever it is possible, try to use some kind of replication of remote data to a local network drive. This can be done with data that doesn't change to often or devolop a good replication mechanism.
>>>
>>>Use as much advantage of Rushmore. The gain of performance by using rushmore is tremendous. I found factors of 1: 1.000.000 (on very large tables) and more.
>>>
>>>It is more efficient to download a lot of data and use it for many modules than to download data every time you enter another module.
>>>
>>>I hope my suggestions will help.
>>>
>>>Good luck.
>>---
>>hi Walter
>>
>>would you please give me a code sample of what you mean by:
>>replication of remote data to a local network drive.
>>
>>thanks
>
>example is keeping a copy of states table (list of state abbreviations) locally.
---
oh - i see...i have done all of that. in the program, there is an option
called SELECT QUERY. when this option is use, the program uses a VIEW to gather
the new set of records. this takes a long time. if i used SET FILTER, it
probably would be faster. what do you think?