2 ms·
From the article: The technique of data normalization is about correct ways of partitioning the data among tables to minimize data redundancy and maximize the s
by aasarava 18y ago
From the article: The technique of data normalization is about correct ways of partitioning the data among tables to minimize data redundancy and maximize the speed of retrieval.
The part about minimizing data redundancy is fine, but I'm not so sure I agree that normalization is really about maximizing speed of retrieval. As we're seeing with high traffic sites, normalization is proving to be one of the biggest bottlenecks because of all the joins it requires.
- rbanffy 18y agoVery true. Normalization is nice, but it usually won't improve performance. If it does, you should fire the guy that designed the previous database ;-)