Tuesday, August 11, 2009

Performance and Drupal

As we worked towards some exciting performance gains, some of our learning

  1. Use Drupal's Page Cache
  2. Run Mysql tuner to understand how Mysql responds to your site
  3. 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.
  4. 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
  5. Queries with inner joins or distinct clause were also marked and reviewed
  6. We had large benefits by restricting the log size, periodic clearing of the session tables
  7. We did add a patch for Drupal look up path and url redirect, will have that appended to this list.
  8. We moved from Drupal search to Google search!
  9. USE of PHP accelerator is a must

Checkout:
  1. Server tuning considerations: http://drupal.org/node/2601
  2. http://2bits.com/articles/performance-logging-module-log-performance-statistics-drupal.html
  3. http://blamcast.net/articles/speed-up-drupal
  4. http://buytaert.net/drupal-performance

1 comment:

Search This Blog

Chennai Drupal Community

drupal.org - Community plumbing

Shyamala's Drupal SEO