From oracle-l-bounce@freelists.org Thu Sep 22 15:57:35 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8MKvZq3013380 for ; Thu, 22 Sep 2005 15:57:35 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8MKvW6H013364 for ; Thu, 22 Sep 2005 15:57:32 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 79BCE1EF015; Thu, 22 Sep 2005 15:51:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15923-03; Thu, 22 Sep 2005 15:51:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0AA221EF45E; Thu, 22 Sep 2005 15:51:45 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=R5X7i8Vp5jzZtVq2nJFCclItEeyRHHu7w6lGj66HZNrcbmwY2owr1KRI5ynX/d5zOA8Q/KcgLRKbsnw7vQ2f4lQNforT76spitHOxrSbYRTnuz/7tSPR2vWGrPqCE0uerVBxzFTHi3XfkXKmQKyxdSe2udMovQ5JHJm7C0VuLkc= Message-ID: Date: Thu, 22 Sep 2005 15:49:48 -0500 From: Dennis Williams To: Nagarajan.Subbiah@aetn.com Subject: Re: Performance over WAN with Latency of xx ms Cc: "oracle-l@freelists.org" In-Reply-To: <30462D80AA52E74698512ADCC4F7EAA32B346C3E@exchange.aetvn.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <30462D80AA52E74698512ADCC4F7EAA32B346C3E@exchange.aetvn.com> X-archive-position: 25810 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: oracledba.williams@gmail.com Precedence: normal Reply-To: oracledba.williams@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.6 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 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