I have a D7 site with around 300,000 nodes. I am passing this function an array of 300-500 nids. Sometimes the function runs in under a second. Sometimes it takes 40 seconds or more! I can't figure out what causes the slow runs. How can I get the query consistent and fast? function _load_field_values_for_nids($field_name, $nids) { $field_info = field_info_field($field_name); $field_id = $field_info['id']; $map = array(); $nodes_without_required_field = []; // Load up the properties from the node table. $sql = 'SELECT * FROM {node} WHERE nid IN (:nids)'; $nodes = db_query($sql, array(':nids' => $nids))->fetchAllAssoc('nid'); // Attach the single field to all nodes. field_attach_load('node', $nodes, FIELD_LOAD_CURRENT, array('field_id' => $field_id)); foreach ($nodes as $nid => $node) { if (isset($node->{$field_name}['und'])) { $map[$node->nid] = $node->{$field_name}['und'][0]['value']; } else { $nodes_without_required_field[] = $node->nid; } } $absent_count = count($nodes_without_required_field); if ($absent_count > 0) { watchdog("vwyw_load_fields", $absent_count." nodes did not have field, \"".$field_name."\" "); } return $map; }