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

Matthew Jones matthew at longsight.com
Mon Apr 2 16:49:17 PDT 2012

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


It doesn't look like the base cache mentioned is being used at all by
default and some mentioned it might have some problems

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.


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 

More information about the production mailing list