gistfile1.php

<?php

//Example 1: fetch all node IDs using db_select
$startTime = microtime(true);
$result = db_select('node', 'n')
    ->fields('n')
    ->execute()
    ->fetchAll();
echo "Elapsed time is: ". (microtime(true) - $startTime) ." seconds";
//prints 0.25 seconds


//Example 2: fetch all nodes using EntityFieldQuery
$startTime2 = microtime(true);
$query = new EntityFieldQuery();
$query->entityCondition('entity_type', 'node')->execute();
echo "Elapsed time is: ". (microtime(true) - $startTime2) ." seconds";
//prints 0.1 seconds