Chapter 8
Database Design and Performance Tuning
Abstract
This chapter looks at practical design choices that can impact the performance of a database. Topics include indexing, clustering, horizontal partitioning, and vertical partitioning.
Keywords
database indexes
database clustering
database partitioning
horizontal partitioning
vertical partitioning
How long are you willing to wait for a computer to respond to your request for information? 30 seconds? 10 seconds? 5 seconds? In truth, we humans are not very patient at all. Even five seconds can seem like an eternity, when you are waiting for something to appear on the screen. A database that has a slow response time to user queries usually means that you will have dissatisfied users.
Slow response ...
Get Relational Database Design and Implementation, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
