mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #04659
[Bug 645744] Re: Automatically delete old notifications from notification_internal_activity
** Changed in: mahara
Status: Fix Committed => Fix Released
** Changed in: mahara
Importance: Undecided => Medium
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/645744
Title:
Automatically delete old notifications from
notification_internal_activity
Status in Mahara ePortfolio:
Fix Released
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.
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/645744/+subscriptions
References