mahara-contributors team mailing list archive

[Richard Mansfield <645744@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
    Milestone: None => 1.4.0

-- 
Automatically delete old notifications from notification_internal_activity
https://bugs.launchpad.net/bugs/645744
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.

Status in Mahara ePortfolio: Fix Committed

Bug description:
The notification_internal_activity table can get pretty big after a while because we rely on users to delete their own notifications.

Some of the more useless notifications could be removed periodically to make upgrades on that table a bit less painful.  See http://mahara.org/interaction/forum/topic.php?id=2287

The worst offenders that would be safe to delete are forum post, view access, watchlist, and institution message  notifications, perhaps just when they're marked as read, and are a few months old.

Most of the 'maharamessage' and ones could go too when they're old, but because that type is a bit of a dumping ground for random system notifications, we'd have to be a bit careful about it.

Others such as the admin notifications and user messages, should just hang around forever because they're not stored anywhere else.