Hacking with PHP has been updated for PHP 7 - click here! >>

Why not separate data?

While normalisation does indeed eliminate data duplication and drastically cut down on the chance of operator error, it does have some side effects. For example, to properly join two tables together to give one result is harder than a normal query, and much harder to optimise. It is also a little slower, because MySQL has to read from several places at once, rather than just one table. Of course, this second downside is negated entirely by the saving in space!


If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: First normal form >>

Previous chapter: So, what is the solution here?

Jump to:


Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.