Re: Comparative performance

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Joe <svn(at)freedomcircle(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Comparative performance
Date: 2005-09-29 13:22:03
Message-ID: 433BEA7B.1050405@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Zeugswetter Andreas DAZ SD 2005-09-29 13:28:27 Re: [PERFORM] A Better External Sort?
Previous Message R, Rajesh (STSD) 2005-09-29 13:05:14 Query in SQL statement