| Index | Recent Threads | Unanswered Threads | Who's Active | Guidelines | Search |
 |
World Community Grid Forums
Category: Support
Forum: Website Support
Thread: Old Forum Posts |
| No member browsing this thread |
|
Thread Status: Active Total posts in this thread: 8
|
|
| Author |
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Does the project need to keep forum posts older than 8 or 10 years. Why not go through the DB and delete all those old posts? Recover disk space, speed up the DB, and reduce clutter. I would suggest anything older than 8 or 10 years is probably not valid anymore. If you absolutely, positively, have to keep the old posts for historical reasons (don't know why) then archive them. Since we are embarking on a new WCG, why not adopt data cleanliness and recover IT resources. Just a suggestion
|
||
|
|
Ian-n-Steve C.
Senior Cruncher United States Joined: May 15, 2020 Post Count: 180 Status: Offline Project Badges: 
|
You’d be surprised how useful even a 10 year old post can be sometimes.
---------------------------------------- EPYC 7V12 / [5] RTX A4000 EPYC 7B12 / [5] RTX 3080Ti + [2] RTX 2080Ti EPYC 7B12 / [6] RTX 3070Ti + [2] RTX 3060 [2] EPYC 7642 / [2] RTX 2080Ti |
||
|
|
Cyclops
Senior Cruncher Joined: Jun 13, 2022 Post Count: 295 Status: Offline |
Hi entity,
Thanks for the suggestion, the team is going to consider this. |
||
|
|
Sgt.Joe
Ace Cruncher USA Joined: Jul 4, 2006 Post Count: 7745 Status: Offline Project Badges: 
|
Does the project need to keep forum posts older than 8 or 10 years. Why not go through the DB and delete all those old posts? Recover disk space, speed up the DB, and reduce clutter. I would suggest anything older than 8 or 10 years is probably not valid anymore. If you absolutely, positively, have to keep the old posts for historical reasons (don't know why) then archive them. Since we are embarking on a new WCG, why not adopt data cleanliness and recover IT resources. Just a suggestion Another way to do this would be to archive any posts from non-active members who are gone for some specified time. Cheers
Sgt. Joe
*Minnesota Crunchers* |
||
|
|
TPCBF
Master Cruncher USA Joined: Jan 2, 2011 Post Count: 1967 Status: Offline Project Badges:
|
What would be the benefit of this, beside A LOT of additional work? I am pretty sure that the forum posts DB is a mere fraction of the overall resources of WCG.
----------------------------------------Ralf  |
||
|
|
Sgt.Joe
Ace Cruncher USA Joined: Jul 4, 2006 Post Count: 7745 Status: Offline Project Badges:
|
What would be the benefit of this, beside A LOT of additional work? I am pretty sure that the forum posts DB is a mere fraction of the overall resources of WCG. Ralf You may right. Just thought I would offer a suggestion anyway. For any good DB admin the the query to do so should be trivial. Cheers
Sgt. Joe
*Minnesota Crunchers* |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
It is good IT practice (Data Lifecycle Management) for many reasons. Some applicable to WCG and some aren't. It only takes work to initially set it up but after that it can be done automatically on a schedule. Why buy resources when you have them already but occupied by something that isn't being used? Seems intuitive that it would be faster to insert a row in 10,000 rows versus 1,000,000 rows. Seems like backups would be quicker and use less resources. Lot of companies end up in court because they are too lazy to clean up their data
|
||
|
|
TPCBF
Master Cruncher USA Joined: Jan 2, 2011 Post Count: 1967 Status: Offline Project Badges:
|
It is good IT practice (Data Lifecycle Management) for many reasons. Some applicable to WCG and some aren't. It only takes work to initially set it up but after that it can be done automatically on a schedule. Why buy resources when you have them already but occupied by something that isn't being used? Seems intuitive that it would be faster to insert a row in 10,000 rows versus 1,000,000 rows. Seems like backups would be quicker and use less resources. Lot of companies end up in court because they are too lazy to clean up their data Being in IT for a long time now (46 years), when using a proper database system to begin with, the time savings for insertion in 10,000 vs 1,000,000 (to stick to your example) will be minimal. Then when you purge old posts, where do you draw the line? Do you include admin/pinned posts? Do you adjust the post counts? Again, I am not sure if the effort is worse the benefits. there are far simpler changes that much more likely improving the usage of the forum. Getting the old icon colors back, yes, that's a pet peeve of mine, but I also know I am not the only one looking forward to that. Specially now that this ghastly color scheme that came with those changes have been rolled back/improved. That's also a rather quick one time change that doesn't cost any resources at all...  Ralf  |
||
|
|
|