Archive Database for older vBulletin threads and posts - Here is an idea - anybody?

[Paul M]

Why not just create an archive forum and move old threads to it ?

[Quarterbore]

In essence that is what I would be doing... Just doing it on the same domain so that the archives are available to my members.

So if my website is at DOMAIN and forums at DOMAIN/FORUMS the archive could sit at DOMAIN/ARCHIVES.

If I go the way you suggest, then the permissions on the second database could be set to allow a select few to edit posts while other usergroups would be read only. Lastly, I would just need to share the user table from the primary database with the secondary one.

I will get to this one of these days... I hope!

[Paul M]

I think you misunderstood.

I mean a simple archive forum, not a whole new board, just a forum on your existing board - to move threads into - why the need to overcomplicate it as you seem to be describing ?

[Quarterbore]

The problem with that is you lose everything that makes vBulletin so great... By having an archive database with the forums, threads, and posts remaining associated with their original forum you can still use the same usergroup permissions... PLUS perhaps put in additional permissions to use the archives.

Now, if you mean to just double the forums on my site... I think we have about 50-forums on my website so to double that would make my head explode... well, I guess I could do that but then creating the searches to only look at the archives would be a nightmare (I think?).

[john1744]

I found that my forum slows down every time we get around 2 million posts (about every 4 months now) so we have to delete posts and start over as we don't have the funds to invest in better server solutions.

A separate database would solve that issue.