Denormalization of large text?
If I have large articles that need to be stored in a database, each associated with many tables would a NoSQL option help? Should I copy开发者_JAVA百科 the 1000 char articles over multiple "buckets", duplicating them each time they are related to a bucket or should I use a normalized MySQL DB with lots of Memcache?
When storing data normalising it is essential, and will save you time further down the line 99% of the time, even if you think you are saving time at the time. Always normalise!
Also you have terminologoy problem, de-normilisation refers to taking normalised data and breaking it down and restoring it as repeated data.
精彩评论