Chapter 7. Database Structure and Performance Tuning
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 aren't very patient at all. Even five seconds can seem like an eternity when you're 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 times can be the result of any number of problems. You might be dealing with a client workstation that isn't properly configured, a poorly written application program, a query involving multiple join operations, a query that requires reading amounts of data from disk, a congested network, or even a ...
Get Relational Database Design and Implementation, 3rd 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.
