As we worked towards some exciting performance gains, some of our learning
- Use Drupal's Page Cache
- Run Mysql tuner to understand how Mysql responds to your site
- We never had in our page/panel or block a code rendered directly from a view, all our view results were cached. The lullabot article on caching, The Beginners guide to caching could be a very good starting point.
- Do not panic by large no of queries, the queries with longer execution time are critical - we focused on the ones on our large tables - NODE, session, user, log, taxonomy tables
- Queries with inner joins or distinct clause were also marked and reviewed
- We had large benefits by restricting the log size, periodic clearing of the session tables
- We did add a patch for Drupal look up path and url redirect, will have that appended to this list.
- We moved from Drupal search to Google search!
- USE of PHP accelerator is a must