i noticed that most of the sql's on 220.127.116.11 and 18.104.22.168 are the same
anyway here are some stored procedures that slows down on me
alter procedure [dbo].[yaf_board_stats]
-- On this else routine 'passing an int parameter to boardid
-- always resulted in sql timeout, that is less than a million posts.
-- I have to alternative but remove this and just use the first select.
-- The error in the forum is when you click the admin link
NumPosts = (select count(1)
from [dbo].[yaf_Message] a
join [dbo].[yaf_Topic] b ON a.TopicID=b.TopicID
join [dbo].[yaf_Forum] c ON b.ForumID=c.ForumID
join [dbo].[yaf_Category] d ON
alter procedure [dbo].[yaf_forum_listread]
join [dbo].[yaf_Forum] b on b.CategoryID=a.CategoryID
join [dbo].[yaf_vaccess] x on x.ForumID=b.ForumID
left outer join [dbo].[yaf_Topic] t ON t.TopicID = [dbo].[yaf_forum_lasttopic](b.ForumID,@UserID,b.LastTopicID,b.LastPosted)
-- the above line of yaf_forum_lasttopic will definitely slow down the
-- main page, sometime an error, most of the the time too slow.
-- what I do is just to replace it with just this
-- ON t.TopicID = b.LastTopicID