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

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?

these are the only hardware details that I know of.

IIS also resides on this machine

Minimum 3GB -- the more the better.

Also... we're talking "real" SQL server here, right? Not SQL Server Express?

If in fact, you are running 1GB of ram. (Please double-check.)

more memory, hmmm..

okey i will try to have it upgraded..

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.

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.

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.

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