[Deploying Sakai] [Building Sakai] Performance issue of synoptic view of announcement tool in home page of "MyWorkspace"

[Matthew Jones]

This appears to be a known issue with no real fix yet. These announcements
are not normally cached.

https://jira.sakaiproject.org/browse/SAK-21511

It doesn't look like the base cache mentioned is being used at all by
default and some mentioned it might have some problems
http://collab.sakaiproject.org/pipermail/sakai-dev/2010-August/008816.html

You might want to double check that ANNOUNCEMENT_MESSAGE CHANNEL_ID and
DRAFT are indexed and optimized (as that ticket mentions, that's the query
that's run). Ideally your database query cache might be able to take some
of this load off (depending on your database). I'm not sure what else to
suggest other than fixing or waiting for that table to be cached.

I don't believe there were any performance enhancements to announcements or
the messages api after 2.6. I know announcements reordering was added,
which added a few new columns. Announcements has had relatively few changes
since 2.6, mostly just bug fixes and this feature.

-Matthew

On Mon, Apr 2, 2012 at 7:03 PM, Jing Wei <jingw at stanford.edu> wrote:

> Hi, All;
>
> At Stanford, we had the performance issue of  the synoptic view of
> announcement tool in home page of "MyWorkspace" which loads all the
> announcements from all the sites that users is joined no matter the site
> is unpublished or hidden in "My Hidden Sites". This causes the loading
> time for home page of "MyWorkspace" extremely long for the users joined
> in many sites.  We are running Sakai 2.6 here.  I would like to know if
> anyone in Sakai community has the same issue and any recommendation for
> the fix. I also would like to know if there are performance fixes on
> Announcement Tool on Sakai 2.8.
>
> Thanks,
>
> Jing
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20120402/e049dd85/attachment.html