Hacker News new | past | comments | ask | show | jobs | submit login
Rise and fall of Third Normal Form (johndcook.com)
6 points by alter8 on Nov 25, 2012 | hide | past | web | favorite | 2 comments



Normal forms don't just (as the article implies) save previously expensive storage; they help defend against still very expensive inconsistent state.


I wished everyone understood this. I can't count the amount of times I've heard arguments like "well, we should store this other bit of data in this table too, so we don't need to perform a join to retrieve it". If you need speed, just use a cache (and proper caching discipline) at the highest level that makes sense, instead of micro-optimizing DB access. It's stupid.




Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact

Search: