gistfile1.md

Analysis of title property loads in Drupal

Task: load title of node

Count: 1'000 (nodes)

The measurement happens on a (close to) clean Drupal 7.34 install. Each iteration started with a clear cache - which can be observed where caching is available and first call is much worse. There are 10 different scenarios:

Note: means and medians are only for times, as memory consumptions are constant through iterations.

1: Noop

2: Single SQL query

$var = db_query("
  SELECT title
  FROM {node}
")->fetchCol();

3: Separate SQL query

$vars = array();
for ($i = 1; $i <= 1000; $i++) {
  $vars[] = db_query("
    SELECT title
    FROM {node}
    WHERE nid = :nid
  ", array(':nid' => $i))->fetchField();
}

4: Using db_select once

$var = db_select('node', 'n')->fields('n', array('title'))->execute()->fetchCol();

5: Using db_select individually

$vars = array();
for ($i = 1; $i <= 1000; $i++) {
  $vars[] = db_select('node', 'n')->fields('n', array('title'))->condition('nid', $i)->execute()->fetchField();
}

6: Loading multiple nodes at once

$nodes = node_load_multiple(range(1, 1000, 1));
$vars = array();
foreach ($nodes as $node) {
  $vars[] = $node->title;
}

7: Loading entities at once

$nodes = entity_load('node', range(1, 1000, 1));
$vars = array();
foreach ($nodes as $node) {
  $vars[] = $node->title;
}

8: Loading nodes separately

$vars = array();
for ($i = 1; $i <= 1000; $i++) {
  $node = node_load($i);
  $vars[] = $node->title;
}

9: Loading nodes separately and using metadata wrapper

$vars = array();
for ($i = 1; $i <= 1000; $i++) {
  $node = node_load($i);
  $entity = entity_metadata_wrapper('node', $node);
  $vars[] = $entity->title->value();
}

10: Using service containers to load content factories and load content individually with node load

$f = cw_tool_get_container()->get('node.controller.factory');
$vars = array();
for ($i = 1; $i <= 1000; $i++) {
  $n = $f->initWithId($i);
  $vars[] = $n->data()->title;
}

Compare times

Compare memory consumption