Reduce load queries

On my site I am seeing user_load() being called 14 times just while viewing a user account. Each of those is doing a query to load the same user_terms data.

This is easy to fix:

function user_terms_load_profile(&$account) {
  static $user_terms = array();
  if (isset($user_terms[$account->uid])) {
    $account->user_terms = $user_terms[$account->uid];
    return;
  }

  $terms  = array();
  $query = "SELECT u.tid, t.vid, t.name FROM {term_user} u 
    INNER JOIN {term_data} t ON t.tid = u.tid 
    INNER JOIN {vocabulary} v ON t.vid = v.vid 
    WHERE u.uid = %d
    ORDER BY v.weight, t.weight, t.name";
  $result = db_query($query, $account->uid);

  while ($term = db_fetch_array($result)) {
    $terms[$term['tid']] = $term;
  }

  $user_terms[$account->uid] = $account->user_terms = $terms;
}

This reduced my query count and time significantly.