forumuser - check that every foriegn key also has a secondary index on it. likewise, make sure there are indexes in child tables which are linked to the parent table (i.e. the child table should have an index on the parentID column).
other than that, can't think of anything else that i've come across.
jimi
http://www.originaltalent.com