Chapter 39. Database Design and Performance
by Bennett McEwan and Ray Rankins
IN THIS CHAPTER
Basic Tenets of Designing for Performance
Logical Database Design Issues
Denormalizing the Database
Database Filegroups and Performance
RAID Technology
Various factors contribute to the optimal performance of a database application. Some of these factors include logical database design (rules of normalization), physical database design (denormalization, indexes, data placement), choice of hardware (SMP servers), network bandwidth (LAN versus WAN), client and server configuration (memory, CPU), data access techniques (ODBC, ADO, OLEDB), and application architecture (two-tier versus n-tier). This chapter will help you understand some of the key database design ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second 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.
