[WG: Sakai QA] [Using Sakai] Forums slowness

[John F. Hall]

Adding and new index on "SAKAI"."MFR_MESSAGE_T" ("IN_REPLY_TO")  just 
helped our performance tremendously (in one case a 1min to 9 sec load time).

Is there an existing Confluence page for database indexing (I looked but 
didn't find one)?  It seems like there's a lot of examples of indexes 
that make a big difference in Forums and other tools scattered in Jiras 
and message board posts.  A single page to collect them all and for 
comments on them might help other find them and get them into future 
Sakai releases. It would also help for checking for ones that might be 
missing after an upgrade or restore.

As for those patches that are in Trunk now, to get them to be candidates 
to be merged into 2.6.x we just need to verify them in a trunk install 
and then mark 2.6.X status as "Merge" if they work, or does someone need 
to create a 2.6-compatible patch first and test it against 2.6.x?

I have a Selenium script to reply to a Forum message in a loop, so I can 
just let that run to generate enough posts to see problems.  The current 
issues we're seeing are based on number of posts, not system load so 
It's easier to reproduce and test.

-John

Clay Fenlason wrote:
> Mathieu:
>
> A few of the issues on your list have fixes in trunk, some of which
> may be appropriate for being merged to 2.6.x if they can be verified
> by QA. Some of them are also slated for a 2.7 release, while Forums is
> itself marching toward an independent release in the next 6 weeks. I'd
> like to take the opportunity, then, to call for active participation
> in Forums QA, especially now. Pete or others in the QA group may have
> thoughts or strategies for doing Forums performance testing, and we're
> in a relatively good position to act on what that testing reveals.
>
> ~Clay
>
> On Mon, Oct 12, 2009 at 2:33 PM, Plourde, Mathieu <mathieu at udel.edu> wrote:
>   
>> Hi,
>>
>>
>>
>> As we explore using Sakai as an alternative to coming to class in case of a
>> flu outbreak, some faculty members have expressed some concern about the
>> slowness of the Forums tool in Sakai when there are a lot of participants
>> and messages.
>>
>>
>>
>> Have your users expressed the same concerns? Did you find a way to fix this
>> slowness? I checked the Sakai Jira tickets and found the following:
>>
>>
>>
>> DF message loading degrades as topic grows
>> http://jira.sakaiproject.org/browse/SAK-8532
>>
>> Slow queries from Forums
>> http://jira.sakaiproject.org/browse/SAK-11463
>>
>> Performance deteriorates for simple actions (ie, New forum, Save and add
>> topic, Save)
>> http://jira.sakaiproject.org/browse/SAK-11186
>>
>> the main forums page loads slowly
>> http://jira.sakaiproject.org/browse/SAK-16848
>>
>> Forums/performance issues.
>> http://jira.sakaiproject.org/browse/SAK-16016
>>
>> Statistics page is still very slow
>> http://jira.sakaiproject.org/browse/SAK-12754
>>
>> Evaluate Forums Performance from a "site with a large number of groups"
>> perspective
>> http://jira.sakaiproject.org/browse/SAK-11798
>>
>> Improve Group performance -- especially Site.getGroupsWithMember() method
>> http://jira.sakaiproject.org/browse/SAK-13312
>>
>>
>>
>> Anyway, any advice or feedback from your institution would be appreciated.
>>
>>
>>
>> Best Regards,
>>
>>
>>
>> =================================
>>
>>
>>
>> Mathieu Plourde, MBA
>>
>> Project Leader, LMS/Instructional Designer
>>
>> IT-Client Support & Services
>>
>> 021 Smith Hall
>>
>> 18 Amstel Avenue
>>
>> Newark, DE 19716
>>
>>
>>
>> Phone: 302-831-4060
>>
>> Fax: 302-831-4205
>>
>> mathieu at udel.edu
>>
>> http://copland.udel.edu/~mathieu/
>>
>>
>>
>> =================================
>>
>>
>>
>> _______________________________________________
>> sakai-user mailing list
>> sakai-user at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>>
>> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org
>> with a subject of "unsubscribe"
>>
>>     
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>   


-- 
____________ John F. Hall ____________
Programmer/Analyst, IT-Web Development
        University of Delaware