← Back to team overview

mahara-contributors team mailing list archive

[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