From: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Subqueries or Joins? Problems with multiple table query |
Date: | 2010-02-23 14:43:13 |
Message-ID: | C2C5D09B-1765-40E2-9C90-8CA6F52ED599@grid.unep.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>> You may also wish to review Andreas' suggestions as they propose a
>>> more sensible table structure rather than having a table for each
>>> convention.
>>
>> The table proposal really looks nice. But our database is structured
>> by variable - so each convention has its own table.
>
> It is a really bad design - it can't scale. A new convention, and you
> have to redesign your database schema (add a new table, rewrite code).
>
> I think, it makes absolutely no sense to invest more work into this,
> sorry, shit.
Thanks for the feedback. We spent a couple of weeks analyzing the
possible solutions for our Portal. And, with lots of feedback from
this group, we decided to go for what we've now. It doesn't seem that
much "scalable"... but in general, with everything we have to do -
preparation of the data, updating of the data etc. - it seems to us
actually as a very smooth solution.
Thanks for your help and your ideas!
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2010-02-23 15:06:39 | Re: SET Role doesn't work from Security Definer Function... |
Previous Message | A. Kretschmer | 2010-02-23 14:38:41 | Re: Subqueries or Joins? Problems with multiple table query |