Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance dilemma
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00343828
Message ID:
00344307
Views:
23
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform