John,

The following advise.
Get Filemon from www.sysinternals.com. It will tell you what goes down the line. You can view which tables are dragged down the line.

Some personal experience:
1. Normal applications just DON'T perform on a WAN.
2. In most instances there is too much delay in the network trafic. Sometimes you can ease the pain by checking if rushmore kicks in when it should. If not, try to optimize the queries that are slow (you can check with filemon)
3. When testing the applications, be sure that mutliple users (or workstations) are using the system as then, no read and write caches occur (opportunistic locking) simulating the real time situation. Withing filemon you can see this anything with "FAST" like FASTIO is indicating oplocking (thus reading from and writing to chache) and most likely is not representative for the production environment.

Sadly, I cannot give you a quick solution other than the following:

1. Install Terminal Services or Citrix on one side and let the other side connect throught that, so that the application does not have to pull its data from the narrow pipeline (yes even T1 is slow).

2. Rewrite your application to SQL server which need far less bandwith in which case a T1 would be just fime.


Walter,





>I have to have a conversation with someone tomorrow about their network. I am in no way a network guru and do not expect to be anytime soon. I just want to know enough to not look completely ignorant.
>
>Network big picture: 2 facilities approx. 5 miles apart. Supposedly there is a T1 line between the 2 facilities.
>
>Network has an app that is used in both facilities, courthouse and jail. Server for this app is at courthouse.
>
>Users at jail have horrible experience i.e. 100 times slower than running app from courthouse.
>
>Approx 6 months ago I entered the picture. I supplied a new VFP app (not related to pre-existing app in any way).
>
>I supplied a server at the jail for this new app.
>
>Users at jail have no problems but users at the courthouse are 100 times slower.
>
>So the problem is the pipe.
>
>I have no idea why so slow but as far as I know the only thing slower than a phone line is carrier pidgeon. How can it be slower than a telephone dialup because it most certainly is.
>
>Thanks,
>John