O'Reilly logo

MySQL by Robert D. Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

III. Optimizing Application Code

8 Advanced SQL Tips

9 Developing High-Speed Applications

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required