Forum OpenACS Q&A: Re: Performance of the server, how can we help?

Collapse
11: Re: Performance of the server, how can we help? (response to 1)
Posted by Dave Bauer on 11/11/03 07:44 PM
forums_message__root_message_id is defined iscachable on newer versions of Forums. The version on OpenACS.org was not. I replaced the function with the newer one.

Using the function to calculate the root message is approximately 30% slower than doing a join on the forums messages table and using tree_sortkey to calculate the root message. Its about 1000% faster using the newer version of the function.

Collapse
16: Re: Performance of the server, how can we help? (response to 11)
Posted by Randy O'Meara on 11/12/03 04:09 AM
Thank you, Dave.

Thanks for taking the time and responsibility to fix this problem. I don't think I'm exagerating when I say that you just helped *every* user of this site and probably will cause uncounted new members to *stay* once they find us.

And, you didn't even stand up and take a bow...