Solved XF is very slow - over 2 sek for Forum Home

[MrFreeze]

There are no add-ons installed! only 30k threads and 3 users

Code:

SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*, `xf_thread_read_Read_6`.*, `xf_forum_read_Read_7`.*

FROM `xf_thread` FORCE INDEX (`last_post_date`)

LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)

LEFT JOIN `xf_node` AS `xf_node_Node_2` ON...

Read more

Continue reading...