Bookmark and Share
About
Features
Blog
Documentation
Support
Welcome Guest Search | Active Topics | Members | Log In | Register

12 Pages«<101112
YAF v1.9.3.3 ALPHA (UPDATED: 2/6/2008)
Options View
Previous Topic Next Topic
Jaben Offline
#166 Posted : Tuesday, April 15, 2008 3:27:17 PM(UTC)

Rank: YAF Head Dude

Medals: 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 Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
YOu need to need some good hardware on that SQL database machine...
"I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
Jaben Offline
#167 Posted : Tuesday, April 15, 2008 3:31:29 PM(UTC)

Rank: YAF Head Dude

Medals: 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 Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
jdadojr wrote:
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.


yaf_topic_latest does not return all topics...

That's what this line is for:

SET ROWCOUNT @NumPosts
"I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
jdadojr Offline
#168 Posted : Tuesday, April 15, 2008 3:47:39 PM(UTC)
Rank: YAF Forumling

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

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
your right, i will look more on this
Back to top
Jaben Offline
#169 Posted : Tuesday, April 15, 2008 4:10:07 PM(UTC)

Rank: YAF Head Dude

Medals: 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 Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
Can you answer the question about the db hardware? I will take further discussion about performance with a grain of salt if you aren't talking about serious hosting.

YAF is DB intensive. SQL Server is resource intensive. There are no free lunches.

Of course, improvements can be made... but I have to know you are being realistic with your expectations.

Are you using "shared" SQL Server hosting?
"I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
 |  Edit by user
jdadojr Offline
#170 Posted : Tuesday, April 15, 2008 4:37:41 PM(UTC)
Rank: YAF Forumling

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

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
We are using a dedicated Xeon Quad 1.86 Ghz with 1GRam, Serial ATA/Raid 5
these are the only hardware details that I know of.
IIS also resides on this machine
Back to top
Jaben Offline
#171 Posted : Tuesday, April 15, 2008 4:39:16 PM(UTC)

Rank: YAF Head Dude

Medals: 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 Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
GET MORE RAM. That is WAY, WAY too little ram for a server that is running both IIS and SQL Server.

Minimum 3GB -- the more the better.

Also... we're talking "real" SQL server here, right? Not SQL Server Express?
"I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
 |  Edit by user
Jaben Offline
#172 Posted : Tuesday, April 15, 2008 4:42:33 PM(UTC)

Rank: YAF Head Dude

Medals: 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 Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
Also... that could explain your speed problems... The ASP.NET caching mechinism doesn't work AT ALL with low RAM resources. It's considered "low priority" and with low system resources it will constantly push the cache out of memory creating a sitution where nothing is cached... so a trip to the DB every time.

If in fact, you are running 1GB of ram. (Please double-check.)
"I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
jdadojr Offline
#173 Posted : Tuesday, April 15, 2008 5:11:08 PM(UTC)
Rank: YAF Forumling

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

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
yes its a real mssql
more memory, hmmm..
okey i will try to have it upgraded..
Back to top
agibby5 Offline
#174 Posted : Tuesday, April 15, 2008 9:38:51 PM(UTC)
Rank: Member

Joined: 3/5/2008(UTC)
Posts: 17

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
jdadojr wrote:
yes its a real mssql
more memory, hmmm..
okey i will try to have it upgraded..


RAM is really, really cheap right now too... no reason not to upgrade.
Back to top
Jaben Offline
#175 Posted : Wednesday, April 16, 2008 6:56:31 AM(UTC)

Rank: YAF Head Dude

Medals: 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 Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
agibby5 wrote:

RAM is really, really cheap right now too... no reason not to upgrade.


That's not true across the board. DDR3 is not cheap. DD2 is cheap... but it could be an older server which requires DDR.
"I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

Back to top
BLOG
 |  Edit by user
agibby5 Offline
#176 Posted : Wednesday, April 16, 2008 7:30:31 AM(UTC)
Rank: Member

Joined: 3/5/2008(UTC)
Posts: 17

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
Jaben wrote:
agibby5 wrote:

RAM is really, really cheap right now too... no reason not to upgrade.


That's not true across the board. DDR3 is not cheap. DD2 is cheap... but it could be an older server which requires DDR.


Not always true... but given the specs he mentioned, I figured it was DDR or DDR2, both are very affordable right now.
Back to top
herman_herman Offline
#177 Posted : Monday, April 21, 2008 7:40:24 PM(UTC)


Rank: YAF MVP

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: 636
Location: Iran - Tehran

Thanks: 57 times
Was thanked: 36 time(s) in 34 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..


Hi
How do you stress test YAf in this way.i mean putting data in the forum.All of the software i have seen so far just test the SQL itself.

Thanks
Half of my life was elapsed in front of monitors, waiting for progress bars to reach their 100%.
Back to top
Demigod Offline
#178 Posted : Friday, May 02, 2008 9:23:49 AM(UTC)
Rank: Advanced Member

Joined: 4/2/2007(UTC)
Posts: 46
Location: Spokane, WA

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
It's been some time since any progress was posted on the status of 1.9.3. Is it any closer to beta or release?
Back to top
WWW
Mek Offline
#179 Posted : Friday, May 02, 2008 5:09:06 PM(UTC)


Rank: YAF Developer

Medals: 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 Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 7/12/2005(UTC)
Posts: 1,899
Location: on Dock Street

Thanks: 2 times
Was thanked: 9 time(s) in 9 post(s)
We're still fixing bugs as our time on the project allows, it's getting there.. just slowly.


"It's a case of RTFM.. the only problem being we don't have a manual!"

When I post FP:Mek in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Ederon Smile )
Back to top
BLOG
Users browsing this topic
Guest
12 Pages«<101112
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.

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.4 RC4 | YAF © 2003-2010, Yet Another Forum.NET
This page was generated in 0.393 seconds.