X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B0627329ECE for ; Thu, 30 Sep 2004 20:17:21 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12899-10 for ; Thu, 30 Sep 2004 19:17:18 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by svr1.postgresql.org (Postfix) with ESMTP id 3848D329ED6 for ; Thu, 30 Sep 2004 20:17:15 +0100 (BST) Received: by mproxy.gmail.com with SMTP id v18so3575162rnb for ; Thu, 30 Sep 2004 12:17:10 -0700 (PDT) Received: by 10.38.1.72 with SMTP id 72mr570292rna; Thu, 30 Sep 2004 12:17:10 -0700 (PDT) Received: by 10.38.206.67 with HTTP; Thu, 30 Sep 2004 12:17:10 -0700 (PDT) Message-ID: <376dd195040930121731d29be3@mail.gmail.com> Date: Fri, 1 Oct 2004 03:17:10 +0800 From: Edwin Eyan Moragas Reply-To: Edwin Eyan Moragas To: Scott Dunn Subject: Re: Web server to Database Taking forever Cc: Josh Berkus , pgsql-performance@postgresql.org In-Reply-To: <200409301858.i8UIwZVd027480@ms-smtp-03-eri0.ohiordc.rr.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <200409300939.04719.josh@agliodbs.com> <200409301858.i8UIwZVd027480@ms-smtp-03-eri0.ohiordc.rr.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/346 X-Sequence-Number: 8474 On Thu, 30 Sep 2004 14:58:27 -0400, Scott Dunn wrote: > It is all working now. The thing is I didn't change anything. So do you > still think its Tomcat or the jdbc driver? > a suspect might be the nature of JSP. on the first hit, JSP is converted to a Servlet, the compiled and loaded by Tomcat. consequent hits would be fast. first one is always slow. how did you connect to the database? -- stp, eyan inhale... inhale... hold... expectorate!