>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 T-1 is on the order of two orders of magnitude slower than the 100BaseT connection. A delay of 2 seconds over 100BaseT would translate into a bit less than 3 minutes over a T-1 ignoring latency and packet issues.
Going to a client-server database rather than VFP's nbative tables to avoid local processing of data in bulk, using remote out-of-process COM servers to do the queryand pass the results, or implementing a thin client solution for the T-1 users are three availble options.