Have you ever tried to make a backup of a 10Gb+ DB? Then how about making alterations to the post table? The upgrade to VB 3.5 was an absolute nightmare with the mods to the post table.
The only time there can be any possible impact on performance is if some of the archives get MAJOR traffic. What I'm doing is only archiving threads that are over 1yr old and in some case older than 200 days. What this does is makes the DB alot easier to manage while still having the contents in a nice and easy format for the search engines. If you know of something better for the truly HUGE boards I'd like to hear about it because I've been trying many things the past few months and archiving to the filesystem is by far the best option.
|