开发者

Denormalization of large text?

开发者 https://www.devze.com 2023-01-03 12:02 出处:网络
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\"

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消