RE: Performance over WAN with Latency of xx ms

The application is basically a web site and making lot of small trips. Currently the application server and the database server are in LAN with the maximum latency of 8ms and the WAN latency may well be guaranteed to the latency of 20 to 25 ms with having enough bandwidth. I believe we could capture the data using the statspack of how much data is being transferred between client and the server. The unknown value would be how many requests are being made by the SQL NET and the JDBC driver as a overhead for the handshaking and other underlying protocols.

-----Original Message-----
From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Thursday, September 22, 2005 4:50 PM To: Nagarajan.Subbiah_at_aetn.com
Cc: oracle-l_at_freelists.org
Subject: Re: Performance over WAN with Latency of xx ms

Subbiah,

> By separating application server in one location and the database
> server in another location and the database connections will be across
> the

I think you need to look at your application architecture. Some applications network better than others. Does the application make a lot of small trips across the network, or just a few larger ones? That is the other issue to consider in addition to network latency. How much latency is acceptable will depend on the architecture and the expectations of your users. If they insist response be as fast as on a LAN, then you better have low latency. If they are more tolerant, then more latency can be tolerated.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l