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:
00017090
Views:
60
through the grids (Scroll bars, page UP/Down, arrow keys, you name it) We are getting anywhere from 2 - 15 second lag times in the screen refreshing when navigating through the grids. Any advice for performance enhancements will be greatly appreciated.
>
>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.
>

1.) Why not have the EXE installed on remote PCs? This would improve performance.
2.) What is your data engine? And is it client/server? Passing entire datasets over the wire is the death of a system. Client/server limits the volume of data transmitted over the wire (based on your fetch rate and stuff). You may want to read some articles on client/server. Inquiry.com has some great reference material for example.
3.) Also, can any data files be stored as free tables on the remote PC. I have done this in the past to improve performance. Tables for validation of data for example.
4.) The slowness of the grid may be a function of the design of your form. Are U using pageframes. If so, U may want to read the threads and other reference material on this forum. There are some very good tips on how to really use pageframes. I am still living with a poorly designed pageframe system and life is difficult.
5.) Are U using optimized SQL stuff to populate the grid. Do U have all of you indicies setup?
Well, just some thoughts-hope this was helpful.
Steve Medvid
Systems Analyst

Environmental Resource Management
Previous
Reply
Map
View

Click here to load this message in the networking platform