[QUOTE=Sean;1332987]one more find. this sql query is causing the remaining lag:

Copying to tmp table | SELECT DISTINCT t.threadid,t.title
FROM post AS p
LEFT JOIN thread AS t ON (p.threadid=t.threa |{/quote]

Trying to find out what component in our software is generating this. I think once we can get rid of that things will be a lot better.
Left/Right/Outer joins can be expensive, more so if the tables aren't indexed for the columns being compared. Sometimes things can be improved by changing the query or by creating/managing an alternative table with less data (which can break normal form rules but I won't tell).