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 47C14329D7A for ; Thu, 23 Sep 2004 18:46:40 +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 13589-05 for ; Thu, 23 Sep 2004 17:46:37 +0000 (GMT) Received: from mail.logi-track.com (burro.logi-track.com [213.239.193.212]) by svr1.postgresql.org (Postfix) with ESMTP id 8A3FE329D3E for ; Thu, 23 Sep 2004 18:46:34 +0100 (BST) Received: from kingfisher.intern.logi-track.com (G6fc4.g.pppool.de [80.185.111.196]) by mail.logi-track.com (Postfix) with ESMTP id 83BC13021D; Thu, 23 Sep 2004 19:46:36 +0200 (CEST) Received: from kingfisher.intern.logi-track.com (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with SMTP id A3742AB352; Thu, 23 Sep 2004 19:46:28 +0200 (CEST) Date: Thu, 23 Sep 2004 19:46:26 +0200 From: Markus Schaber To: "Jason Coene" Cc: "'Mr Pink'" , "'Scott Kirkwood'" , Subject: Re: Caching of Queries Message-ID: <20040923194626.708b7bce@kingfisher.intern.logi-track.com> In-Reply-To: <200409231653.i8NGrUaX017580@ms-smtp-02.nyroc.rr.com> References: <20040923152925.18234.qmail@web41114.mail.yahoo.com> <200409231653.i8NGrUaX017580@ms-smtp-02.nyroc.rr.com> Organization: logi-track ag, =?ISO-8859-15?Q?z=FCrich?= X-Mailer: Sylpheed-Claws 0.9.12a (GTK+ 1.2.10; i386-pc-linux-gnu) X-Face: Nx5T&>Nj$VrVPv}sC3IL&)TqHHOKCz/|)R$i"*r@w0{*I6w; UNU_hdl1J4NI_m{IMztq=>cmM}1gCLbAF+9\#CGkG8}Y{x%SuQ>1#t:; Z(|\qdd[i]HStki~#w1$TPF}:0w-7"S\Ev|_a$K wrote: > I've looked at PREPARE, but apparently it only lasts per-session - that's > worthless in our case (web based service, one connection per data-requiri= ng > connection). This sounds like the loads of connection init and close may be the reason for the slowdown. Can you use connection pooling in your service? HTH, Markus --=20 markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 z=FCrich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com