Not sure if this is the correct forum for this topic ... pls move it if it should be elsewhere...
Our forums (forums.mtbr.com) are getting rather large...
1,700,000 posts
51,386 members
175,000 threads
Our posts table is almost 1GB large. I've been preaching and preaching to our site's owner that he should prune old messages, users, posts, etc. But each message, potential page view, is $$. He balks at pruning anything.
So is there a reason why exporting threads to real .html isn't in the software? (the /archive/ directory only works if you want to keep stuff in the mysql database.) I need to make the posts table smaller. (I also want to change the index to full-text, but it took 13 hours on our dev server. That amount of downtime is ... bleh.)
The con side of a "real" .html export is that the vB search engine will not work on flat html files... only google will work for that ... and that is ... bleh too.
Maybe if I can get some real-life examples of pruning ... some sort of pruning based on thread inactivity … or some formula to determine which dead, uninteresting, troll threads should be pruned? Maybe if I get good suggestions from this community I can convice the powers at hand that pruning is the norm ... and vB communities expect it?
Anyone else face the same issues?
LMK
- MikeG
Our forums (forums.mtbr.com) are getting rather large...
1,700,000 posts
51,386 members
175,000 threads
Our posts table is almost 1GB large. I've been preaching and preaching to our site's owner that he should prune old messages, users, posts, etc. But each message, potential page view, is $$. He balks at pruning anything.
So is there a reason why exporting threads to real .html isn't in the software? (the /archive/ directory only works if you want to keep stuff in the mysql database.) I need to make the posts table smaller. (I also want to change the index to full-text, but it took 13 hours on our dev server. That amount of downtime is ... bleh.)
The con side of a "real" .html export is that the vB search engine will not work on flat html files... only google will work for that ... and that is ... bleh too.
Maybe if I can get some real-life examples of pruning ... some sort of pruning based on thread inactivity … or some formula to determine which dead, uninteresting, troll threads should be pruned? Maybe if I get good suggestions from this community I can convice the powers at hand that pruning is the norm ... and vB communities expect it?
Anyone else face the same issues?
LMK
- MikeG
Comment