I'm still working on the sphinxsearch issue (and it doesn't look good). But I've spent a lot of time looking at mytop and one thing caught my attention - there's a lot of
SELECT COUNT(*) AS earlierPosts FROM post AS post WHERE post.threadid = xxx AND post.visible = 1 AND post.dateline =...