Re: Creating tons of tables to support a query - Mailing list pgsql-general

On Sun, Sep 08, 2002 at 23:58:44 +0200,
  Jan Ploski <jpljpl@gmx.de> wrote:
>
> select count(*) from message where sectionID = ? and dateSent > ?

If the dateDent is the same for each query, you should probably be doing
it in one query. Something like:
select sectionID, count(*) from message where dateSent > ? group by sectionID