The only issue we have run into is that the Guest user is shown every 'forum' twice in the category list, as in when the guest loads the forum and the 'root' page is displayed, all the forums are 'duplicated' in the list. This behavior is not exhibited when a user is logged in.

You could try logging in as your YAF 'Host' administrator account and re-indexing your tables in the database. I believe we did this back then and it resolved the duplicate topics and forums for the guest user. As bbobb said, it's very very rare that it would happen. Since that one time, after we re-indexed, we have yet to see it again.

I ran the following re-index command for all tables.

DBCC DBREINDEX ('yaf_WatchTopic', ' ', 80)

But the issue still exist. Any recommandation?

Thanks,

Thoa

I already was writing about the problem 100500+ times. Unfortunately, I don't have more time because I'm forced to do with my data layers independently.

Is there anything I can do to prevent this issue in the future?

Thanks,

Thoa

There will be no a lot of guest users. The situation is very rare and therefore was not fixed. The fix implies steady perfomance downgrade in a very busy sql script. The reason of this is MS SQL Server unreliable transaction locking. Logic works fine.

I am now experience a performance issue. My forum runs very slow. Since it's a new forum, the database has a very small amount of data. We do not have a lot of users at this point. But it runs very slow.

I have an old forum in ASP which located in the same host but it runs very fast with a large SQL Server database. I afraid to bring those data over to this new YAF forum. It already runs very slow without any data.

Any suggestion?

Thanks