Denormalization

Now we tackle one of the most oft' asked questions: What about Denormalization? The real answer is this: Ask a dozen database developers and you'll get a dozen opinions.

Many people who denormalize their database structures do so for “performance reasons”. Here are some of the problems they claim to encounter:

  • Queries run slowly.

  • Reports take too long to print.

  • On-screen forms take time to populate.

  • Web pages take too long to populate.

Speed and performance are really relative to a user's definition of the terms. What some people may consider painfully slow may be as fast as greased lightning for others. You should always take performance complaints with a grain of salt and try to take the time to investigate the true ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.