i noticed that most of the sql's on 1.9.1.8 and 1.9.3.3 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
else begin
select
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]
..
..
x.ReadAccess
from
[dbo].[yaf_Category] a
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