Clean up >400K attachments
Forum has more than 400K attachments after 8 years. Running the existing AdminCP / Forum and Posts / Attachments / Find Orphaned Attachments does not seem practical on a volume this large. It has never finished even after hours of time. With nary an indication of progress beyond "Scanning Step 2, Please Wait".
I know there are some missing attachments due to incomplete transfer during server migrations the past 5 years. I'd like to clean up the concordance between the database and the saved files. So, some questions:
1. Code in admin/modules/forum/attachment.php for orphans goes through the entire set. Is there a way to modify existing core code to apply a date range to the search?
2. What query with date range would generate a suitable list for manual comparison?
3. Or perhaps a thread-based indication of missing attachments for moderation?
4. Or perhaps a UserCP-based indicator in Manage Attachments that looks to see if there is a file in the system?
Thoughts?
How does a Big Board manage this?
I know there are some missing attachments due to incomplete transfer during server migrations the past 5 years. I'd like to clean up the concordance between the database and the saved files. So, some questions:
1. Code in admin/modules/forum/attachment.php for orphans goes through the entire set. Is there a way to modify existing core code to apply a date range to the search?
2. What query with date range would generate a suitable list for manual comparison?
3. Or perhaps a thread-based indication of missing attachments for moderation?
4. Or perhaps a UserCP-based indicator in Manage Attachments that looks to see if there is a file in the system?
Thoughts?
How does a Big Board manage this?