one more find. this sql query is causing the remaining lag:

[quote] 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.