X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0EA64D9C29
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Sep 2005 10:22:06 -0300 (ADT)
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 98211-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Sep 2005 13:22:01 +0000 (GMT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.186])
	by svr1.postgresql.org (Postfix) with ESMTP id 7420ED9B7D
	for <pgsql-performance@postgresql.org>;
	Thu, 29 Sep 2005 10:22:02 -0300 (ADT)
Received: from p548F2309.dip0.t-ipconnect.de [84.143.35.9]
	(helo=pse.dyndns.org)
	by mrelayeu.kundenserver.de with ESMTP (Nemesis),
	id 0ML2Dk-1EKyMP1clJ-0005i6; Thu, 29 Sep 2005 15:22:05 +0200
Received: from pse1 ([192.168.0.3]) by pse.dyndns.org with esmtp (Exim 4.44)
	id 1EKyMN-0006uR-QE; Thu, 29 Sep 2005 15:22:03 +0200
Message-ID: <433BEA7B.1050405@pse-consulting.de>
Date: Thu, 29 Sep 2005 15:22:03 +0200
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Joe <svn@freedomcircle.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Comparative performance
References: <433B4AA4.9080008@freedomcircle.net> <op.sxu1g5bnth1vuj@localhost>
	<433BDFF3.3090402@freedomcircle.net>
In-Reply-To: <433BDFF3.3090402@freedomcircle.net>
X-Enigmail-Version: 0.89.5.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:0ce7ee5c3478b8d72edd8e05ccd40b70
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.186 required=5 tests=[AWL=0.136,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200509/418
X-Sequence-Number: 14726

Joe wrote:

> 
> 
> The pages do use a number of queries to collect all the data for display 
> but nowhere near 50.  I'd say it's probably less than a dozen.  
> 
> The schema is fairly simple having two main tables: topic and entry 
> (sort of like account and transaction in an accounting scenario).  There 
> are two additional tables that perhaps could be merged into the entry 
> table 

Hm, if you only have 4 tables, why do you need 12 queries?
To reduce queries, join them in the query; no need to merge them 
physically. If you have only two main tables, I'd bet you only need 1-2 
queries for the whole page.

Regards,
Andreas