Q&A
| Q1: | This all sounds complicated, and I just have a simple system. Do I really need to learn this? |
| A1: | In systems that you're developing for interest only, or in light-traffic systems, probably No.
However, most serious systems experience more significant traffic and usage at some point in their life span, so performance should be something that's built in to the design in all but the most trivial databases. |
| Q2: | If I were to do one thing to improve performance, what should it be? |
| A2: | In almost all cases, add indexes to tables where appropriate. |
Get Sams Teach Yourself MySQL in 21 Days, 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.
