Step one for properly un-frakking a db/forum caving under a mountain of old posts:
Set up a system to archive the old hosts into a separate read-only db/forum after a thread has gone X days without being updated.
File-cache that archive.
That lets you truncate/optimize the "live" db and keep it manageable.
Set up a system to archive the old hosts into a separate read-only db/forum after a thread has gone X days without being updated.
File-cache that archive.
That lets you truncate/optimize the "live" db and keep it manageable.