From: Andreas Pflug <pgadmin@pse-consulting.de>
To: Joe <svn@freedomcircle.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Comparative performance
Date: Thu, 29 Sep 2005 15:22:03 +0200
Message-ID: <433BEA7B.1050405@pse-consulting.de> (raw)
In-Reply-To: <433BDFF3.3090402@freedomcircle.net>
References: <433B4AA4.9080008@freedomcircle.net>
<op.sxu1g5bnth1vuj@localhost>
<433BDFF3.3090402@freedomcircle.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgadmin@pse-consulting.de, svn@freedomcircle.net
Subject: Re: Comparative performance
In-Reply-To: <433BEA7B.1050405@pse-consulting.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox