Mass Prune Threads By Last VIEWED Date

[ryand789]

Hello,

I was just starting to do some mass pruning, but had some concerns. (My database is up to 2.6 GIGS.)

I was deleting some threads, but noticed that there were some GOOD threads being deleted! They were old, but had some really good information on bodybuilding and nutrition. I believe these posts are a good resource for future users and I would love to leave them there for when people search on certain subjects...

So there may not have been any new POSTS in a thread for over 6 months, but there may have been a lot of people VIEWING the posts and getting the information from them.

Is there a way to delete threads where they have not been VIEWED for over X days?

What about a way to delete threads where that are over X days old that have had ZERO replies? There a lot of useless threads like that which can be deleted real quick. You know the kind of thread...

On a side note, I am deleted posts mainly because our search is starting to SLOW down. How much more would it slow down if I change it from 4 letter minimum to 3 letter minimum? There a lot of product and workout names that are three letters only and it really makes it tough to search for them... (like ZMA, HIT, SAN...)

Thanks a ton for your help! I hope there is a way to do what I asked above and if not, hopefully there will be in the near future.

PARTY ON!

Ryan DeLuca
Bodybuilding.com