[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 johnjamesjacoby):

 1000 seems high for most traditional WordPress hosting company servers.
 It’s possible trying to delete 1000 records will lock the database table
 for a few seconds.

 If this is a stab in the dark, we should probably be more conservative:
 250, but more frequently?

 I’m also reluctant to push this change to core, like at all.
 Facebook/Twitter/LinkedIn and others don’t purge my old
 notifications/mentions/etc… The point of storing them is to keep them
 around, and removing them with a cron means it will happen somewhat
 randomly to end users without their acknowledgement.

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