RDarling
  •  RDarling
  • 56% (Neutral)
  • YAF Camper Topic Starter
2011-03-08T23:25:39Z
When a user views the homepage it takes a very long time to load. I think I have pinpointed the issue but I cannot find out how to resolve it.

When debugging the front page reports [dbo].[yaf_forum_listread]: 41.168

I looked into the sproc yaf_forum_listread and found out that when it tries to run the view yaf_vaccess it takes for ever and I believe this is because we have 2,903 Users and 105 forums. These forums are deleted and recreated about every 3 months (we have to do this) and after everytime we recreate them the forum starts to runs slow, even after reindexing all the tables.

The view yaf_vaccess return 307213 rows.

Any idea on how to speed this up? And unfortunately Indexing is out of the question since the view contains the MAX aggregate function.

Thanks for any help.

Robert

YAF Ver 1.9.301
SQL 2005
Sponsor
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2011-03-08T23:31:22Z
Upgrade to a newer version of YAF.NET (say, v1.9.5.5).

The issue was fixed a while ago.
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2011-03-08T23:32:07Z
I see you say indexing is out the question... you'll be interested to see how I optimized this system, than 🙂
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2011-03-09T04:53:46Z
Originally Posted by: RDarling 

When a user views the homepage it takes a very long time to load. I think I have pinpointed the issue but I cannot find out how to resolve it.

When debugging the front page reports [dbo].[yaf_forum_listread]: 41.168

I looked into the sproc yaf_forum_listread and found out that when it tries to run the view yaf_vaccess it takes for ever and I believe this is because we have 2,903 Users and 105 forums. These forums are deleted and recreated about every 3 months (we have to do this) and after everytime we recreate them the forum starts to runs slow, even after reindexing all the tables.

The view yaf_vaccess return 307213 rows.

Any idea on how to speed this up? And unfortunately Indexing is out of the question since the view contains the MAX aggregate function.


Yes, the perfomance issue solved in 1.9.5.5 RTW. I added a separate table which stores access data for users online only. So no more huge tables. The table doesn't contain indexes at all - it holds highly volatile data. For 99% yaf installations it hugely improves perfomance.
On the other hand, when you load start page I've added a more demandin forum_listread sp, but it loads only once. It was previously insane: if you had 20 forums with subforums on a start page - the procedure wa loaded 21 times :cheesy:
I've added database paging for posts in a topic - now perfomance is best even if you have thousands posts in topics. So with member list - the perfomance doesn't depend on number of users
These compensated Autofac related slowness and as result YAF works fast as never :-d
So the 1.9.5.5 is revolutionary one - it allows easy plugin inteagration and no loose coupling thanks to Jaben and it works faster. Everyone is happy!
Thoa
  •  Thoa
  • 50.2% (Neutral)
  • YAF Camper
2012-12-06T08:00:02Z
Some how this SLOW issue is coming back in YAF 1.9.6.1. Any idea?

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved