Drupal How many JOINs is too many? Tuning optimizer_search_depth for MySQL with Drupal Drupal is extremely flexible, and creates a highly normalised table structure, 2 tables per field on a piece of content. We were seeing SQL queries appear to never complete when they had lots of JOINs in them.
MySQL Finding and killing long running SQL queries in AWS RDS Occasionally we find sites that are running extremely slowly, and digging down we end up finding MySQL queries that have been running, for sometimes days or even weeks.
Performance Preparing for a high traffic event, simple steps to success The steps that any new launch or high traffic event should go through in order to have the best chance of success.
Drupal Dynamic content caching based on attributes in Drupal 7 Simple code to maximise your varnish hitrate
Drupal Debugging Drupal performance with Cache Debug module Finding the offenders breaking your caching strategy
Drupal High performance AJAX callbacks with Drupal 7 and the JS module Make lightning fast AJAX queries in Drupal 7
Drupal Profiling Drupal 7 performance with XHProf and Devel Find out why Drupal is consuming the memory it is
Drupal How to speed up Drupal by altering the tokens UI On larger Drupal sites, the Token module quickly becomes unwieldy, and the UI can consume precious resources while often being never used. Here are some options for mitigation of this.
