(Forum.cs Line 81)
hoping to get some ideas guys, so that I can work around.
is 18.104.22.168 ready to use, or still being tested , i realy would love to upgrade
thanks for the efforts
what is the latest stable version of yaf, i am currently using 22.214.171.124is 126.96.36.199 ready to use, or still being tested , i realy would love to upgradethanks for the efforts
what is the latest stable version of yaf, i am currently using 188.8.131.52
184.108.40.206 is latest stable, 1.9.3.x is alpha
Just to ask if there is going to be any update to 1.9.3.probably 220.127.116.11 or the beta version.
To me it is stable enough to enter Beta!
As I have noticed, slowdowns and bottlenecks causing sql timeouts are in the sql aggregation queries.
You may need to have tables for computed colums and sql jobs to update those tables.
Keep up the good work anyway..
Hi there yavdevs, currently I am stress testing your yaf. Putting in around 40K users and 3Million posts.As I have noticed, slowdowns and bottlenecks causing sql timeouts are in the sql aggregation queries.You may need to have tables for computed colums and sql jobs to update those tables.Keep up the good work anyway..
Hi there yavdevs, currently I am stress testing your yaf. Putting in around 40K users and 3Million posts.
Which version of YAF? It would be of great assistance if you could provide some specifics on which database functions are exponentially slower.
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
now on 2Million post
also on the
ALTER procedure [dbo].[yaf_forum_moderators]
-- i have to replace it with
-- that is specifically targeted to moderators
-- else sql timeout will occur..
I can see it needs performance tuning -- page generation times are in the 25+ second arena.
You running the SQL DB on a dedicated box? What kind of IO? RAID 5 array of 15K SCSI drives? How much ram? 8GBs?
This DB has to have massive IO and RAM requirements.
What forum were you running before -- on what DB?
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.