mahara-contributors team mailing list archive

[Richard Mansfield <645744@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
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: New

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.