I recently launched an site used yetanotherforum. After several days of activities that yaf I have a very serious problem that is performance, site load very slowly and frequent table lock or deadlock, with the topic have much messages, the problem worse. I think that members yaf development should focus on the performance of the system (especially stored procedure) and avoid load all data to web server. Sorry about the english is not good. Hope later versions will be better yaf, respectfully.
My site:
http://forum.sanotc.com
Sorry to hear you're having problems. Any specifics on the speed problems would be appreciated. For instance, do you know which stored procedure you've having speed problems with? Have you tried the latest version of YAF (v1.9.4 RC4) that includes quite a few performance improvements?
Thanks Jaben.
Performance slow with table have large data
ex:
a. Stored procedure "yaf_user_list" with table yaf_User and table yaf_Prov_Membership very slow when load More 200000 user (Members in my forum)
b. Stored procedure "yaf_topic_list" slow when load topic have large messages.
Reason: "yaf_user_list" and "yaf_topic_list" not paging in stored procedure, instead they're load all data and paging in web server.
My Solution: I tried paging in stored procedure
respectfully.