[buddypress-trac] [BuddyPress Trac] #7534: Remove read notifications from the DB table after a specified time period

[buddypress-trac]

#7534: Remove read notifications from the DB table after a specified time period
--------------------------+----------------------------------
 Reporter:  r-a-y         |       Owner:
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  Under Consideration
Component:  Performance   |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |
--------------------------+----------------------------------

Comment (by r-a-y):

 > The query to remove notifications for all users based on their last
 activity is a scary one. We'd need to know the last_activity date for all
 users to purge the notifications table of old read ones across the board.

 I was thinking of doing a date query against the notification table's
 `date_notified` column and check `is_new = 0`.

 But:

 > Give users a "Delete read notifications instantly" type setting

 A per-user setting would make this more complicated.

 > because that clean-up routine would need to run every day across all
 users

 Perhaps run every week or every month?

 > If we are going to start running periodic clean-up routines, at the risk
 of making this a bigger deal, there are other things that could benefit
 (stale friend requests, groups, etc...)

 Friend requests and groups are more pertinent data.  If a group is empty
 with no activity, then sure.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/7534#comment:3>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac