9.8.3 Why not separate data?This is NOT the latest copy of this book; click here for the latest version.
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!
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
