[Building Sakai] Cleaning messages tables in database

[Bryan Holladay]

Sakai does a soft delete on most everything. This is why you can delete
things and re-add them and the data will still be there if you have the
same ID (e.g. users, sites, tools, etc). There is work being done on hard
deleting site https://jira.sakaiproject.org/browse/SAK-26217 but I'm not
sure if it covers Msgcntr. I did a quick search and didn't see anything.
Once hard delete is completely finished, I would consider that the
"standard" to use.

On Sat, Oct 18, 2014 at 11:55 AM, Gregory Guthrie <guthrie at mum.edu> wrote:

> 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>
>
> 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:
>
>
>
> -------------------------------------------
>
>
>
> _______________________________________________
> 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/sakai-dev/attachments/20141020/af7d53b2/attachment.html