Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition
by Michael J. Hernandez
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access