by Bennett McEwan and Ray Rankins
IN THIS CHAPTER
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 issues that will ensure you have a reliable and high-performance application.