YAFLogo

Kaan1983
  • Kaan1983
  • 91.4% (Exalted)
  • YAF Forumling
14 years ago
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.

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer Topic Starter
14 years ago
Please post in the Bugs & Problems v1.9.3.3. This is not the place to discuss this problem.
Kaan1983
  • Kaan1983
  • 91.4% (Exalted)
  • YAF Forumling
14 years ago
Sorry, I moved my post, please feel free to delete these ones
ash360
  • ash360
  • 100% (Exalted)
  • YAF Commander
14 years ago
what is the latest stable version of yaf, i am currently using 1.9.1.6

is 1.9.3.3 ready to use, or still being tested , i realy would love to upgrade

thanks for the efforts


Visit my Forums: FORUMZ360.com 
Ederon
  • Ederon
  • 100% (Exalted)
  • YAF Developer
14 years ago
ash360 wrote:

what is the latest stable version of yaf, i am currently using 1.9.1.6

is 1.9.3.3 ready to use, or still being tested , i realy would love to upgrade

thanks for the efforts

1.9.1.7 is latest stable, 1.9.3.x is alpha


When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.
herman_herman
14 years ago
Hi

Just to ask if there is going to be any update to 1.9.3.probably 1.9.3.4 or the beta version.

To me it is stable enough to enter Beta!

Thanks

Ederon
  • Ederon
  • 100% (Exalted)
  • YAF Developer
14 years ago
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.
When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.
jdadojr
  • jdadojr
  • 55.4% (Neutral)
  • YAF Forumling
14 years ago
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..

sastry.kodavanti
14 years ago
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer Topic Starter
14 years ago
jdadojr wrote:

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..

Which version of YAF? It would be of great assistance if you could provide some specifics on which database functions are exponentially slower.

jdadojr
  • jdadojr
  • 55.4% (Neutral)
  • YAF Forumling
14 years ago
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

----------------

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer Topic Starter
14 years ago
Where is this "million post" forum?
jdadojr
  • jdadojr
  • 55.4% (Neutral)
  • YAF Forumling
14 years ago
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..

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer Topic Starter
14 years ago
Yes, that is a large forum. I wish I had such a large forum to mess with so I could do performance testing with it.

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?

jdadojr
  • jdadojr
  • 55.4% (Neutral)
  • YAF Forumling
14 years ago
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.