I'm hoping for one of the following:
Archive Table Type: MySQL5+ requirement, will cut the size of topics down to being miniscule, and i hear it works quite well.
Archives in a seperate table: (no mysql version requirement), would put your archived forum data into a seperate table as to cut down on any rebuilds of active content.
Archives as Flat Files: not a database hit, simply write out the content to flat files on the users system.
