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 | 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 | Lists | API | Security | Legal | Apply to YC | Contact