Need help understanding network problems

Hi All,

We have an Oracle 8 server on NT 4 sp 5. We are attaching locally to it and everything is fine. When we run the app across the WAN to a site across the country the application is unusable (Lag from Florida to Utah is horrible).

Some info:
We are using VB5(sp3) with OO4O 2.3
Assume that the SQL calls are as good as they can be (indexed correctly, very trim, etc.)
We are going through MCI who does our backbone. We are using Frame Relay.
A ping from the client has 3 hops, one to it's router, one to our router, and finally to the Oracle server. A regular ping from the client is 100 ms (approx.) A TNSPing from the client is 240 ms (approx.) We are using Net8 with TCPIP.
In our TNSNAMES.ORA file we specify IP, not the oracle name All logging on the server has been turned off (Per Oracle support) Our guaranteed throughput is 16K with a max burst of 512K MCI says that we are using little (if any) of our speed (basically, they are saying it's not them)

My question is this, how are other companies able to do this? I had thought that Oracle was "prime" for this sort of thing? I recognize that there will be some lag but shouldn't this ping be okay? Why does TNSPing return such a high (almost double a regular) ping?

Anyone out there using Frame Relay? If so, what issues have you had. And finally, what are some other possible solutions you may have.

TIA,
Dave Received on Tue Oct 26 1999 - 17:03:41 CDT