Part III: Optimizing Application Code

After learning how to understand and influence the MySQL optimizer, design your tables for speed, and create the right kinds of indexes on these tables, it's now time to turn your attention to developing the fastest possible MySQL-based solution.

Chapter 8, "Advanced SQL Tips," cites many examples showing how your choice of SQL can have a dramatic impact on your application's speed.

Chapter 9, "Developing High-Speed Applications," examines how to create the most efficient application logic. This includes taking advantage of MySQL's new stored procedures, managing transactions and concurrency, language-specific tips, and steps you can take to reduce unnecessary application overhead.

8 Advanced SQL Tips

9 Developing High-Speed Applications