That's strange - you should have the p_rfl index, and we found we were running into speed problems in some cases without it. Try running this query:
ALTER TABLE gforum_Post ADD INDEX p_rfl (post_root_id, forum_id_fk, post_latest_reply)
Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Code:
ALTER TABLE gforum_Post ADD INDEX p_rfl (post_root_id, forum_id_fk, post_latest_reply)
Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com