| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Mel Jamero <mel(at)gmanmi(dot)tv> |
| Cc: | 'Dani Oderbolz' <oderbolz(at)ecologic(dot)de>, 'pgsql-novice' <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: sql question (hopefully) |
| Date: | 2003-06-18 14:37:44 |
| Message-ID: | 20030618143744.GC20256@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, Jun 18, 2003 at 22:40:49 +0800,
Mel Jamero <mel(at)gmanmi(dot)tv> wrote:
>
> The reason why I didn't normalize was because i would've ended up with
> millions of tuples and the reply from the database would be too slow for the
> application(s) we built. I tried to come up with a better schema but I
> couldn't find one that really returns a fast reply so I settled with the one
> i presented.
>
> I did break other rules of proper Relational Analysis and Design for the
> sake of fast replies we needed. I'll send it to this list in the future to
> get better ideas. I just have to solve our current problem.
Did you actually test both the normalized and denormalized versions to see
which is faster?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mel Jamero | 2003-06-18 14:40:49 | Re: sql question (hopefully) |
| Previous Message | Mel Jamero | 2003-06-18 14:30:45 | Re: sql question (hopefully) |