Welcome Guest! To enable all features please Login or Register.
12 Pages«<9101112>
Options
View
Go to last post Go to first unread
Offline Kaan1983  
#151 Posted : Friday, March 28, 2008 5:06:10 PM(UTC)
Kaan1983

Rank: Advanced Member

Reputation:

Joined: 7/25/2007(UTC)
Posts: 65

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.
Offline Jaben  
#152 Posted : Friday, March 28, 2008 6:41:50 PM(UTC)
Jaben


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 2,549
Location: United States

Thanks: 142 times
Was thanked: 358 time(s) in 199 post(s)
Please post in the Bugs & Problems v1.9.3.3. This is not the place to discuss this problem.
Offline Kaan1983  
#153 Posted : Friday, March 28, 2008 7:37:02 PM(UTC)
Kaan1983

Rank: Advanced Member

Reputation:

Joined: 7/25/2007(UTC)
Posts: 65

Sorry, I moved my post, please feel free to delete these ones
Offline ash360  
#154 Posted : Sunday, March 30, 2008 8:56:38 PM(UTC)
ash360


Rank: YAF Commander

Reputation:

Joined: 3/27/2008(UTC)
Posts: 94

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
Offline Ederon  
#155 Posted : Sunday, March 30, 2008 9:03:42 PM(UTC)
Ederon


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Red Supporter: Thank you Daniel for supporting YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

Joined: 1/7/2007(UTC)
Posts: 902

Thanks: 3 times
Was thanked: 11 time(s) in 9 post(s)
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.
UserPostedImage
Offline herman_herman  
#156 Posted : Friday, April 11, 2008 3:46:21 PM(UTC)
herman_herman


Rank: YAF MVP

Reputation:

Medals: Medal of Honor for the SQL Scout: Medal for kicking ass at SQL and helping with database development.Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for The Eyes of the Community: Given for being a community hawk, always watching and helping fellow users.

Joined: 5/18/2007(UTC)
Posts: 529
Man
Iran (Islamic Republic Of)

Thanks: 72 times
Was thanked: 47 time(s) in 38 post(s)
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
Half of my life was elapsed in front of monitors, waiting for progress bars to reach their 100%.
Offline Ederon  
#157 Posted : Saturday, April 12, 2008 8:13:11 PM(UTC)
Ederon


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Red Supporter: Thank you Daniel for supporting YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

Joined: 1/7/2007(UTC)
Posts: 902

Thanks: 3 times
Was thanked: 11 time(s) in 9 post(s)
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.
UserPostedImage
Offline jdadojr  
#158 Posted : Sunday, April 13, 2008 7:59:22 PM(UTC)
jdadojr


Rank: YAF Forumling

Reputation:

Joined: 4/1/2008(UTC)
Posts: 9

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..
Offline sastry.kodavanti  
#159 Posted : Monday, April 14, 2008 1:37:33 AM(UTC)
sastry.kodavanti


Rank: YAF Forumling

Reputation:

Joined: 3/24/2008(UTC)
Posts: 4

Updated
Offline Jaben  
#160 Posted : Monday, April 14, 2008 5:32:57 PM(UTC)
Jaben


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 2,549
Location: United States

Thanks: 142 times
Was thanked: 358 time(s) in 199 post(s)
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.
Offline jdadojr  
#161 Posted : Monday, April 14, 2008 7:25:23 PM(UTC)
jdadojr


Rank: YAF Forumling

Reputation:

Joined: 4/1/2008(UTC)
Posts: 9

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





Offline Jaben  
#162 Posted : Tuesday, April 15, 2008 7:24:12 AM(UTC)
Jaben


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 2,549
Location: United States

Thanks: 142 times
Was thanked: 358 time(s) in 199 post(s)
Where is this "million post" forum?
Offline jdadojr  
#163 Posted : Tuesday, April 15, 2008 10:10:41 AM(UTC)
jdadojr


Rank: YAF Forumling

Reputation:

Joined: 4/1/2008(UTC)
Posts: 9

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

Offline Jaben  
#164 Posted : Tuesday, April 15, 2008 2:25:09 PM(UTC)
Jaben


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 2,549
Location: United States

Thanks: 142 times
Was thanked: 358 time(s) in 199 post(s)
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?
Offline jdadojr  
#165 Posted : Tuesday, April 15, 2008 3:12:09 PM(UTC)
jdadojr


Rank: YAF Forumling

Reputation:

Joined: 4/1/2008(UTC)
Posts: 9

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.

Rss Feed  Atom Feed
Users browsing this topic
12 Pages«<9101112>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error