Performance - Pixelite

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

How to profile PHP memory with Drupal

Simple steps to tune your application

Drupal

How and why you should update PHP to PHP 5.5 with Drupal

You should do this yesterday

Drupal

High performance AJAX callbacks with Drupal 7 and the JS module

Make lightning fast AJAX queries in Drupal 7

Drupal

Using EntityCache to speed up your Drupal site

Make your Drupal 7 sites faster

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.