From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Table Relationships |
Date: | 2003-05-30 17:03:19 |
Message-ID: | 200305301003.19829.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Andrew,
> Are you sure you want to say it that strongly? After all, if you
> have a data set which needs always to be returned in the same static
> format, why not just denormalise it? It's sure faster that way in
> every system I've ever encountered.
>
> It's only when you actually have relations to cope with that it
> ceases to be an advantage. So, as usual, it depends on what you're
> trying to do.
Yeah, I suppose so ... if all they're doing is reporting on a static set of
data which is not transactional ... sure. If it's a disposable,
limited-time-use application.
However, I have yet to see in my professional experience any application that
was really this way and stayed this way once it was in use ... relations have
a way of creeping in, and planning for them is less messy than refactoring.
--
Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-05-30 17:17:39 | Re: Hardware advice |
Previous Message | Adam Witney | 2003-05-30 16:55:40 | Re: Hardware advice |