term_cache.sql

# Given a table term_article_count(tid, node_count) 
# the following could be executed to refresh a node count cache.

TRUNCATE term_article_count;

INSERT INTO term_article_count(tid, node_count)
  SELECT tn.tid, COUNT(n.nid)
  FROM term_node AS tn
    INNER JOIN node AS n ON (tn.vid=n.vid AND n.type='location' AND n.status=1)
  GROUP BY tn.tid;