[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:  3.0
Component:  Performance             |     Version:
 Severity:  normal                  |  Resolution:
 Keywords:  dev-feedback has-patch  |
------------------------------------+------------------

Comment (by r-a-y):

 We can drop the deletion limit to 250 or lower and can increase the date
 limit to something older like three months if that helps.

 WordPress purges trashed posts with cron (see `wp_scheduled_delete()`,
 `wp_delete_auto_drafts()`).  I understand that read notifications are
 different and are not exactly "trashed", but once you've marked a
 notification as read, the likelihood of ever going back to an older, read
 notification is extremely rare.

 If we want to give some acknowledgment, we can also add a message on the
 "Notifications > Read" screen that read notifications older than X days
 will be removed.

 If we don't want to run this with WP cron, then maybe this can be added as
 a tool under "Tools > BuddyPress" in the admin area or as a wp-cli
 command.

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