On Wed, Jun 18, 2003 at 22:40:49 +0800,
Mel Jamero <mel@gmanmi.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?