this friend of mine got some permision problems: YAF.Classes.Base.ForumPage
(Forum.cs Line 81)
hoping to get some ideas guys, so that I can work around.

Sorry, I moved my post, please feel free to delete these ones

1.9.1.7 is latest stable, 1.9.3.x is alpha

Yes, there will be at least beta followed by RC or FINAL. Depending on how stable/ready it is. Now we struggle with lack of time for this project, which might hopefully get better in some time.

Updated

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

---

this is my experimental yaf forum
now on 2Million post

http://216.128.24.132/

---

also on the
ALTER procedure [dbo].[yaf_forum_moderators]
...
...
from
[dbo].[yaf_vaccessfull]
...
-- i have to replace it with
-- [dbo].[yaf_vaccessfull_mods]
-- that is specifically targeted to moderators
-- else sql timeout will occur..

I again made some modification and make it a litte faster now.

I can see that the yaf_topic_latest will return all the
topics that a user has rights to(all 13K of topics that is).

I modify the yaf_topic_latest to return nothing at all
and looks like there is no effect on the forum itself but much faster response.

Our last forum was a hosted IPB but since we are being hacked time and
again we transfer to CS forum. However it looks like that CS
also suffer from some sort of slowdown to death.

Now I am trying your Yaf, hoping this will make a difference.