Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh Very, Very, Very Slow
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00326864
Message ID:
00326878
Views:
23
>I have an application where some of the users access the data over a T-1 line. The form refresh for the T-1 users is extremely slow. The refresh is just just fine for those on the 100Base-T LAN. The SEEKs work acceptably fast (1-2 seconds), despite the fact that I'm directly accessing fairly large tables (3 million records in the parent). Then the THISFORM.REFRESH takes several minutes.
>
>The forms are part of a formset (Yes, I now know better) of three forms. The largest form has 15-20 fields, including one pageframe, bound to the data. Most of the tables are read-only and I also have optimistic row-buffering on for the few, small tables that are editable. I have also tried only refreshing the necessary fields, and that does not seem to help.
>
>And if it matters, DELETED is OFF and I have no deleted records. The EXE is run off of each user's C-drive. I am using the default REFRESH method.
>
>Any suggestions or solutions would be appreciated.

It seems fairly obvious... don't attempt to access the data on a T-1, it's only 1/100 the speed of your LAN at peek throughput.

If you must give client access via the T-1, you may want to consider a thin client solution.

HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform