PDA

View Full Version : archive posts

joshskeety
01-10-2009, 09:20 PM
Is there a way or a hack to archive posts into a seperate database so that users can go back and look at a year prior?

I have a 2 million post forum and due to my post table being so big now, Vbulletin is struggling..

Thanks,

Josh

--------------- Added 1231634219 at 1231634219 ---------------

Is there no way to do this?

Josh
Dismounted
01-11-2009, 04:41 AM
There is no way to do this in a default installation of vBulletin.
joshskeety
01-11-2009, 03:13 PM
It is a shame that you cant. Having a 2 gig post table in an open source SQL is asking for too much... Because of what my forum is, I can't just prune. I can't believe there is no way to do this, or that this doesn't come standard in Vbulletin..
Bellardia
01-11-2009, 03:28 PM
Consider splitting your board into two forums with shared login and userdata?
You would achieve the same effect. It's not really hard to believe that this doesn't come standard...it's not that common of a problem.
joshskeety
01-11-2009, 05:54 PM
Consider splitting your board into two forums with shared login and userdata?
You would achieve the same effect. It's not really hard to believe that this doesn't come standard...it's not that common of a problem.

I have thought about doing that, however, I would have to create a daily cron that can move tables from one database to the other so that the users table and other tables would move over without users being able to tell that in the archive they are actually using a different database. I do not run my own webserver anymore so I would have to see if this would be available on the virtual server I am running now..

I don't see how this isn't a more common problem. Granted, I know my forum is way bigger than most, but it is more than likely not the biggest out there.. With my size of forum, you lliterally have to optimize daily to ensure the database is running smoothly, being able to seperate the posts by year to another database would fix this problem..

Josh
Dismounted
01-12-2009, 04:26 AM
I can't believe there is no way to do this
There is a way to do this - but that requires coding on your own/hiring someone to do it.