Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow Grids in Remote User App
Message
 
To
10/01/1997 21:38:28
John Adams
John T. Adams Software Consulting Svcs
Keedysville, Maryland, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00017077
Message ID:
00017091
Views:
60
>To answer the first few questions...
>
>Most users have 14.4 or 28.8 Modems, VFP 5.0 is not currently an option, nor is running the app locally on the field rep PC.
>
>TIA,
>
>John

1.) Are U C/S? What is your data engine? If U are not C/S then transmitting entire data sets over the wire is not a good thing. Check this forum for discussion on C/S and other sites like Inquiry.Com.
2.) Install EXEs locally on remote PCs. This will help performance. If U are worried about keeping version in sync; setup a small routine in the startup program to verify the current version...
3.) Can any data files be setup as free tables on the local PCs? Data files for validation for example.
4.) Are Ur SQL statements optimized. ie; Do all of your tables have the proper indices setup?
5.) Are U using pageframes? If so, are the optimized? There is a good set of discussion items on this formum related to optimizing pageframes.
6.) Is there any other stuff in your forms that are slowing U down. Create a test form with just the grid and do some bench marking so U know where U stand. This might be the first thing I would try. It may give U justification to go to a Client/Server environment.
Well this is the third submission; hopefully it will get through... It must be snowing somewhere
Let me know if any of this stuff helped...
Steve
Steve Medvid
Systems Analyst

Environmental Resource Management
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform