in reply to [untitled node, ID 308077]
Method 1 is worse (worst?). Your table is denormalized, and you will run into a maintainance nightmare.
It is not unusual to use denormalized tables in a data warehouse today, but in normal database, NO.
Don't worry about large table, as long as it is properly indexed, not a really big deal, how big can it be? The most important thing is to do it right.
|
|---|