I switched from vBulletin 4.0.4 to XenForo 1.1.0 a week ago. Since the changeover I have some issues with the server latency and load average (see attachments). Sometimes it takes really long until a clicked page comes up and I also had some double postings from members because of that. My provider told me that the reason are some slow querys (which are locking the tables): Code: 2011-12-10 09:41:44 | dbXXXXXXXX[dbXXXXXXXX] @ local3 [127.0.0.3] | 00:00:13 | SELECT thread.* , user.*, IF(user.username IS NULL, thread.username, user.username) AS username, node.title AS node_title, forum.*, permission.cache_value AS node_permission_cache FROM xf_thread AS thread LEFT JOIN xf_user AS user ON (user.user_id = thread.user_id) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_permission_cache_content AS permission ON (permission.permission_combination_id = 1 AND permission.content_type = 'node' AND permission.content_id = thread.node_id) WHERE (forum.find_new = 1) ORDER BY thread.last_post_date DESC LIMIT 120 Is there a way to fix that?