UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support any database diet tips? my forum is HUGE, and I'm looking to lose a few

granted, my boards are pretty old -- nearly 10 years or so. and, yeah, they've got a good string of regular traffic, over 1mil posts. and, perhaps the most damning, i hate deleting old content, so i never prune.

but, all that said... i really never thought my boards would be that big. as stands, my "gz" sql backups are 200 MB. according to the cpanel for my site, my entire mysql space is about 1.5 GB.

besides literally just nuking threads or forums here and there (which i truly want to avoid) is there anything i can do to "diet" a bit? like, because my forum has gone through years of ubb upgrades and such, maybe the structures are just old and need to be "cleaned" to streamline? and then i'll drop about 500 MB/LBs?

I recently went from UBB 'Classic' 6.x (license was from ~2002 or so - upgrading since 1999) to the new 7.5.3 Threads, have never pruned posts (have about 1/2 of yours) and I can say that my load has reduced significantly.

YMMV-

The only way you're going to reduce the size of the database is by pruning, no way around that one. Speed can be improved by things like tuning the MySQL install, but it looks like you're just wanting to reduce the size itself.

I should note, that one of the reasons the database is so large is that we keep two copies of each post. One the already marked up version (all ubbcode converted) and one of the original post, for editing purposes.

For version 8 we'll be introducing an archive feature, so you can archive older posts. When posts are archived, we will no longer keep the original post, only the marked up one. So those people that have a lot of older posts can choose to archive those, which will free up quite a bit of space.

Hehe, I love when my feature suggestions get implemented in the stock product

yeah, its not the load or speed so much as it is the size.

does "archiving" mean that the thread can no longer be responded to, only viewed? (and if so, would there be a ... "frankenstein" feature, to bring them back if ever need be?)

Yes, archiving will be view only.

As for bringing them back. Since we're tossing the original post, possibly, but any edits to the one archived posts would lose any ubbcode formatting, unless we write a ubbcode_decode function which would be a major PITA.

You know, I actually wrote one for my news scripts lol

haha

i'd be more than fine with "locking in" those original posts, ala "is that your final answer?" the only thing i don't like is losing conversations (either through pruning or locking). if threads just became permanent after a month or year or whatever, to trim up the db, that'd beautiful.