Re^4: Mapping objects to database tables

Re extracting the person's name into a separate table....

I could do it, but all it buys me is a small reduction in table size, and it costs me an extra join (or two) for every announcement lookup.

It would be a bit like extracting a date into its own table.

Comment on Re^4: Mapping objects to database tables

Replies are listed 'Best First'.
Re^5: Mapping objects to database tables by pajout (Curate) on Nov 07, 2006 at 14:48 UTC
Yes, this is up to you :>) My experience is that only experience in time shows the optimal solution - normalization is good advice, but it is not an idol. Somebody prefers optimization for reading and somebody for updating.	[reply]