Quote:
Originally Posted by MarcoH64
The biggest problem with any archive solution would be how to include it in a search and don't loose performance.
|
Currently we only allow searches on the past 4 months, which is a separate table on a slave database machine used only for searching. In the scenario above we'd have to rely on other search engines. It sucks but it isn't any worse than what we're already doing, heh.
Also, I forgot to mention in the original post that one of the reasons I want to keep the data in the database itself is to be able to easily revert what I've done should vBulletin ever make their own archival method. With this setup you simply throw all of the archive tables back into the post.