Hello,
I just recently launched an site and after a few days worth of activity, we are seeing serious performance issues with the forums. The site was load tested extensively and held up very well under a heavy load after making one modification to an index in the yaf_Active table to eliminate a deadlocking issue that we were seeing. So, I'm reluctant to think that it's a load issue at this point, but I'm not sure what else could be impacting performance this dramatically.

http://community.constantcontact.com/forum/ 

Any thoughts?

Thanks in advance!
Brian

I believe that I have identified the problem. We had an invalid IP address for the SMTP server in the Host Settings. As soon as I removed the IP all together, the boards starting performing normally again....

What is the exact change you did?

I believe that I have identified the problem. We had an invalid IP address for the SMTP server in the Host Settings. As soon as I removed the IP all together, the boards starting performing normally again....

Glad you worked it out.

If the SMTP setting caused your server to slow down, you have a serious DNS issue!! Make sure your server has entries for all IP's (and domains!) or it will just run in a circle!!

---

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 

---

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 

Did you migrate your content from another forum?

You've got some huge threads! I think some have over 5000 pages. That's a very impressive forum you have, even though I don't understand a word of it. I found the performance quite good when I had a look.

😁

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?

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.

---

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

Yes, only database paging makes it work fast. You've done what's required.😎
Current version works faster as some things are separated, but it still returns too many tuples to work faster. IMO.