[Building Sakai] Cleaning messages tables in database

[Gregory Guthrie]

Should 't such cleanup be automatic, or was something broken in this case?



Is there a standard way to delete old courses that will cleanup all associated artifacts?



------------------------------------------------

Date: Fri, 17 Oct 2014 09:42:26 -0400

From: Bryan Holladay <holladay at longsight.com<mailto:holladay at longsight.com>>

Subject: Re: [Building Sakai] Cleaning messages tables in database

... (lots of fancy SQL magic...)

>

> We are experiencing some slowness in Message Center tool. Taking a look on

> database, our table mfr_pvt_msg_usr_t has about 4,5 millions of rows.

>

> A simple query shows that a big percent of these messages are related to

> old sites that don't exist anymore:

-------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20141018/f5b9461a/attachment.html