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

The issue was fixed a while ago.

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!