| | 14 | |
| | 15 | Other thoughts: |
| | 16 | |
| | 17 | * 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. |
| | 18 | * I don't think deleting all read notifications that are over 30 days old makes sense, because that clean-up routine would need to run every day across all users |
| | 19 | * 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...) |