View Full Version : Forum pruning this week
CheapyD
10-01-2006, 09:53 PM
In an effort to keep the database more managable, and improve site performance, I'm going to be deleting some old threads.
I think I will start with the CAG Trading forum and Off Topic forums.
I'll probably use the criteria of any thread created more than a year ago that has not received a reply in a year. If you want to save any such thread, I'd recommend posting a reply in it soon.
Thanks!
Goodbye old threads :cry:
zewone
10-01-2006, 09:56 PM
No wayz! My postz countz will go down!
No wayz! My postz countz will go down!
Yeah, I dont wanna lose my legendary Nintendo porn thread.
http://www.cheapassgamer.com/forums/showthread.php?t=26019
:cry: Good times.
CheapyD
10-01-2006, 10:08 PM
I think you were kidding, but your post count will not go down.
If you have any special requests (for closed threads that you don't want to die), perhaps I can honor them.
Please post a link.
Stoneage
10-01-2006, 10:09 PM
EB morning update, may you rot in....heaven......damn dirty apes!!!!
moiety
10-01-2006, 10:14 PM
Could you keep the 2005 Yardsale thread? I still go back and read it from time to time. :) Thanks Cheapy!
Ikohn4ever
10-01-2006, 10:16 PM
most bump all year old threads
I think you were kidding, but your post count will not go down.
If you have any special requests (for closed threads that you don't want to die), perhaps I can honor them.
Please post a link.
off the top of my head:
http://www.cheapassgamer.com/forums/showthread.php?t=11456
http://www.cheapassgamer.com/forums/showthread.php?t=30470
http://www.cheapassgamer.com/forums/showthread.php?t=26019
http://www.cheapassgamer.com/forums/showthread.php?t=63029
http://www.cheapassgamer.com/forums/showthread.php?t=31145
http://www.cheapassgamer.com/forums/showthread.php?t=15186
http://www.cheapassgamer.com/forums/showthread.php?t=48205
edit. These threads should probably be Wiki'd.
Scorch
10-01-2006, 10:42 PM
Keep the wrestling threads or i'll have your head on a plate in Yokohama by noon.
And if for some cruel reason you decide to delete the wrestling threads, please keep the Eddie Guerrero thread.
zewone
10-01-2006, 11:06 PM
http://www.cheapassgamer.com/forums/showthread.php?t=11923
http://www.cheapassgamer.com/forums/showthread.php?t=64905
I'm trying to find the thread where DLF first posted the "bitch tits" picture and the "Cloudspek ripped me off" one. Those are keepers.
zewone
10-01-2006, 11:13 PM
I thought I remember hearing that Cloudspek got accidently deleted. :cry:
I thought I remember hearing that Cloudspek got accidently deleted. :cry:
Maybe thats why. Here's this one though: http://www.cheapassgamer.com/forums/showthread.php?t=12351
FriskyTanuki
10-02-2006, 03:07 AM
http://www.cheapassgamer.com/forums/showthread.php?t=223
http://www.cheapassgamer.com/forums/showthread.php?t=483
http://www.cheapassgamer.com/forums/showthread.php?t=4215
http://www.cheapassgamer.com/forums/showthread.php?t=25188
http://www.cheapassgamer.com/forums/showthread.php?t=27508
http://www.cheapassgamer.com/forums/showthread.php?t=14998
Delete all of the wrestling threads though.
DT778
10-02-2006, 03:18 AM
the last one you linked isn't worth saving.
zewone
10-02-2006, 03:25 AM
http://www.cheapassgamer.com/forums/showthread.php?t=42867
This contains the greatest phrase known to mankind. Please keep it around.
Graystone
10-02-2006, 03:30 AM
I say delete all of the old wrestling threads.
Ugamer_X
10-02-2006, 05:13 AM
I need all of these:
http://www.cheapassgamer.com/forums/showthread.php?t=64063
http://www.cheapassgamer.com/forums/showthread.php?t=54578
http://www.cheapassgamer.com/forums/showthread.php?t=54585
http://www.cheapassgamer.com/forums/showthread.php?t=54617
http://www.cheapassgamer.com/forums/showthread.php?t=55154
http://www.cheapassgamer.com/forums/showthread.php?t=55154&goto=nextnewest
http://www.cheapassgamer.com/forums/showthread.php?t=54617&goto=nextnewest
http://www.cheapassgamer.com/forums/showthread.php?t=67157
Actually, if you could just leave the whole Halo 2 forum alone I'd be eternally grateful.
Trakan
10-02-2006, 06:52 AM
Actually, if you could just leave the whole Halo 2 forum alone I'd be eternally grateful.
As would I. Please leave them.
shrike4242
10-02-2006, 11:25 AM
I'd recommend going through all forums and flushing out all threads older than a year. VGD forum especially, since any deal over a year old isn't likely valid anymore.
Asking for threads to be preserved will only hamstring working on cleaning out the database, since numerous useless threads will be kept alive with someone posting in them. It should be an across-the-board cleaning for anything older than a year, no exceptions. Anything of real importance in that timeframe should be moved into the Wiki.
Anything of real importance in that timeframe should be moved into the Wiki.
I agree.
Also, this one's a classic: http://www.cheapassgamer.com/forums/showthread.php?t=11653
Edit. Ya know, its mainly the older CAGs who dont wanna see these great threads die. They bring back memories.
CocheseUGA
10-02-2006, 08:04 PM
http://www.cheapassgamer.com/forums/showthread.php?t=42867
This contains the greatest phrase known to mankind. Please keep it around.
Being...?
pop311
10-02-2006, 08:14 PM
Being...?thinking the same thing as you
Z-Saber
10-02-2006, 08:51 PM
Keep the EBgames morning update threads. Then send Gamestop links to them and see what kind of sales they're missing now that they've screwed up the website.
zewone
10-02-2006, 09:16 PM
Being...?
He is a close friend of mine, and I wll not stand for it, sir.
Classic.
CheapyD
10-02-2006, 09:29 PM
Anything of real importance in that timeframe should be moved into the Wiki.Can't argue with that. CAGwiki editors...combine and make wiki!
evilmax17
10-02-2006, 09:37 PM
How does one transfer a thread to a wiki?
b0bx13
10-02-2006, 09:53 PM
Requesting preservation of the Jailbait Appreciation thread (wiki or otherwise): http://cheapassgamer.com/forums/showthread.php?t=54577
GizmoGC
10-04-2006, 01:12 AM
Make sure to keep all of mousins threads if you havn't already...poor little buddy :-(
CheapyD
10-04-2006, 01:33 AM
How does one transfer a thread to a wiki?
I guess you just write a summary of it.
Ugamer_X
10-04-2006, 01:44 AM
I guess you just write a summary of it.
If you can save a few specific threads and trash the rest, I don't see the point in taking the time to write a summary about it. Not only that, but half the fun is in actually reading the thread as a whole, unabridged.
allout1986
10-04-2006, 02:15 AM
Maybe you can make an area on the forums for the old threads that you're keeping. Lock them all and they'll have their own section in the forums... I guess similar to the Deal Graveyard forum in the Deal Discussion/Bragging Rights forum.
Ugamer_X
10-04-2006, 02:30 AM
Maybe you can make an area on the forums for the old threads that you're keeping. Lock them all and they'll have their own section in the forums... I guess similar to the Deal Graveyard forum in the Deal Discussion/Bragging Rights forum.
That's a good idea.
Z-Saber
10-04-2006, 09:11 AM
That's a good idea.That problem is all those old threads take up server space and lag the whole thing down, especially if you're doing a search.
I guess you just write a summary of it.
That's what I was thinking. A summary, highlights, and memorable quotes and images.
Pookymeister
10-04-2006, 08:35 PM
That problem is all those old threads take up server space and lag the whole thing down, especially if you're doing a search. I guess it depends on the ratio of "to be saved threads" to "to be deleted threads". If theres 10000 to be trashed and 50 saved, it might not hurt performance that much.
Ugamer_X
10-05-2006, 01:46 AM
That problem is all those old threads take up server space and lag the whole thing down, especially if you're doing a search.
If you can explain to me how saving 100 threads out of 30,000 would have a significant adverse effect on the site's performance, then I'll rescind my request for saving them.
GuilewasNK
10-05-2006, 01:54 AM
I'd recommend going through all forums and flushing out all threads older than a year. VGD forum especially, since any deal over a year old isn't likely valid anymore.
Asking for threads to be preserved will only hamstring working on cleaning out the database, since numerous useless threads will be kept alive with someone posting in them. It should be an across-the-board cleaning for anything older than a year, no exceptions. Anything of real importance in that timeframe should be moved into the Wiki.
You beat me to it with that post. You pretty much said everything I was going to say. If there is no response for a year then it should be gone.
kjauburn
10-05-2006, 02:03 AM
Now sure if its a option with some db optimization you could probably just leave everything as is, unless actually disk space is becoming a issue. My guess is there probably isn't alot of maint. done on the db in general and setting up a few monthly routines could go a long way. You could run a trace on the duration of the queries to see if any are taking to long, plus you could use indexing and consider spliting the data file for better performance. I am sure there is a least one MySQL expert on here who might be able to help, all my time is spent in SQL Server and Oracle...
Roufuss
10-05-2006, 11:28 AM
I'm curious, these people that want to save old threads, how often are you going back and reading them? Or are you just bitching for no apparent reason and never would have thought of this or cared if Cheapy just wiped out old threads and didn't tell anyone?
This seems to fall under the category of "I want to keep old threads for the one day 5 years into the future I want to read them".
I'd rather have CAG running faster (to get deal faster) and letting Cheapy and crew do the maintence they need to do then preserve a bunch of old threads no one is reading.
evilmax17
10-05-2006, 12:07 PM
I don't think its unreasonable to want to save a few old threads for historical purposes. Cheapy went about it in the exact right way, saying he was going to delete old threads, and asking people if they wanted anything saved. People have asked for less than 20 threads to be saved, are those 20 threads being deleted REALLY going to make CAG run THAT much faster?
To those saying summarize it in the wiki, that defeats the whole point. Imagine if somebody summarized the Bible in wiki form, and then burned all of the original transcripts. "God talks to a bunch of people, and some stuff happens." Doesn't have quite the same effect does it?
As I said, I don't see what's so unreasonable with how Cheapy originally went about this. At all. People should be posting the names of the threads in their posts, to make it easier to see as he goes through them. If he wanted to just do a full purge, he could easily create a temp forum to place the saved threads, and then just move them back.
Also, there are some really good threads that have been locked. You can't respond to a locked thread, which is why many of them won't have responses for over a year. That doesn't make them less worthy of saving.
I read through some of my old favorite threads about once a month. Like I said, it's a historical thing. Saving ~50 threads after all is said and done won't affect much of anything performance wise.
GuilewasNK
10-05-2006, 12:17 PM
All people have to do is go up File-Save As and they save whatever pages they want themselves. It doesn't matter to me either way though.
Xevious
10-05-2006, 04:02 PM
I think we should keep all the Youtube threads.
Also, there are 8 million threads about the DS screen protectors that need to be deleted. I should sign up for the wiki and condense all the information about that there...
Dr Mario Kart
10-05-2006, 04:14 PM
Would it help if you killed old forum users that havent logged in or anything forever?
Ugamer_X
10-05-2006, 04:43 PM
I'm curious, these people that want to save old threads, how often are you going back and reading them? Or are you just bitching for no apparent reason and never would have thought of this or cared if Cheapy just wiped out old threads and didn't tell anyone?
This seems to fall under the category of "I want to keep old threads for the one day 5 years into the future I want to read them".
I'd rather have CAG running faster (to get deal faster) and letting Cheapy and crew do the maintence they need to do then preserve a bunch of old threads no one is reading.
If you can explain to me how saving 100 threads out of 30,000 would have a significant adverse effect on the site's performance, then I'll rescind my request for saving them.
.
GuilewasNK
10-06-2006, 02:44 AM
.
Originally Posted by munch
Before people want to save old threads, they should ask themselves, "Is this shit really important?"
Ugamer_X
10-06-2006, 06:00 AM
Originally Posted by munch
Before people want to save old threads, they should ask themselves, "Is this shit really important?"
It was obviously important enough for the head cheapass to make a thread about it.
guinaevere
10-06-2006, 11:21 PM
Ya know, its mainly the older CAGs who dont wanna see these great threads die. They bring back memories.You have to let the past go, my friend. Enjoy the memories, but make new ones here and now.
(was that cliche enough?)
To serious issues, I had made a suggestion in the stickie thread about combining deal threads, so there is only one Uber thread per store(s), rather than one thread per week. As old sales go out, update the OP and keep on top of deleting posts of no real value or no longer relevent. The OP would naturally have current sales listed, and then next weeks promotions.
The sticky issue had me thinking that a few things could be streamlined (in the deals forums at least) as a sort of preventative maintenance for server related issues.
Roufuss
10-07-2006, 08:06 PM
The dude who is bumping all the collection threads in the sub forums, most which died a year or more ago and only reached two pages at most - give me a break.
These threads will get saved from pruning only to die again and rot for another two years.
CheapyD
10-09-2006, 12:48 AM
FYI, I've deleted a bunch of old threads, but only ones that have had 10 or less replies. There were so many! I'll probably do some similar type pruning in the near future, but it doesn't look like I'll need to do anything too heavy.
One of these days, I would like to rebuild the search index too.
Mr. Anderson
10-16-2006, 04:42 AM
I need all of these:
http://www.cheapassgamer.com/forums/showthread.php?t=64063
http://www.cheapassgamer.com/forums/showthread.php?t=54578
http://www.cheapassgamer.com/forums/showthread.php?t=54585
http://www.cheapassgamer.com/forums/showthread.php?t=54617
http://www.cheapassgamer.com/forums/showthread.php?t=55154
http://www.cheapassgamer.com/forums/showthread.php?t=55154&goto=nextnewest
http://www.cheapassgamer.com/forums/showthread.php?t=54617&goto=nextnewest
http://www.cheapassgamer.com/forums/showthread.php?t=67157
Actually, if you could just leave the whole Halo 2 forum alone I'd be eternally grateful.
Man, that brought back some memories.
fart_bubble
10-16-2006, 05:36 PM
http://www.cheapassgamer.com/forums/showthread.php?t=42867
This contains the greatest phrase known to mankind. Please keep it around.
Oh man, I forgot all about that thread.
This thread MUST stay: http://www.cheapassgamer.com/forums/showthread.php?t=15173
(DLF Exposed!)