>Hi Pierre,
>
>>
>>For instance trying to do an incremental search of a lookup drop down list cannot be done efficiently or in some cases at all.
>>
>
>To be sure try only to use,browse and scroll from the VFP Command Window maybe this will show you are able to found a solution.
>
>Actually I am working to optimize my application to run on a 4MB Token Ring
>( Sometime BandWidth goes to 1MB or less )
>
>Using a Network Monitor with the VFP debug Window I was able to reduce the network traffic ( 50% )
>
>Marcel
As everybody has already suggested -- definitely move your EXEs to local workstations.
You can redesign your application to use remote views -- even against native VFP tables. You will have to make sure your queries are very simple (no functions not even native VFP ones in queries for example) to get decent performance.
If you have lookup tables don't change too often you could try making them workstation tables -- local copies on the workstation that are reloaded at time of loading application only if server side tables have changed . I believe there is an old foxpro advisor that suggests a way of doing this (and still keeping everything in synch), but I don't remember the year or issue.
Thanks
Gar W. Lipow