slow query

Hello,

I've been trying to figure out why our drupal site is going slow . . . this has ranged from disabling modules (update status and statistics) to looking into the slow queries log.

When I look into the log, the overwhelming majority of the entries are from term_data or term_node

E.g:

SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 169 ORDER BY v.weight, t.weight, t.name

and