>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