Tuning Queries and Schema/Indexes can significantly increase performance of your application and decrease response times.
For example (assuming appropriate hardware and MySQL configuration):
1. Additional my.cnf tuning (after the initial tuning): 10% performance increase
2. Schema, indexes and query tuning: up to 1000% (or even more) response time increase
In this... [read more]