mahara-contributors team mailing list archive

[Eugene <645744@xxxxxxxxxxxxxxxxxx>]

Richard - I have written a patch that should get us going on this one ;).
I have added a core cronjob function that will delete stale (read and older than 21days) 'viewaccess', 'institutionmessage', 'watchlist', 'feedback' and 'newpost' notifications.

See the patch and let me know what you think.

** Patch added: "cron.patch"
   https://bugs.launchpad.net/mahara/+bug/645744/+attachment/1674415/+files/cron.patch

-- 
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.