Archive Hack

[WetWired]

Pezman, the webmaster for the Infogrames North America forums (or the INA, as most call it), probably one of the largest vB forums out there, posted a problem at vB.com.
[Link] (http://www.vbulletin.com/forum/showthread.php?threadid=62705)

Basicly, putting old posts into archive forums really doesn't reduce their effect on the server. When you have 2 million posts, I can easily understand how this can be a major drag on the operation.

My suggestion was to create new post and thread tables which are only used on forums marked as archive forums, or when an "Include archives in search" checkbox is checked when doing a search.

Though the original request was to solve a problem on a huge forum, I think it could be of use on moderately large forums also, and I would use it if it was created.

I would do it myself, except I am currently knee deep in a multi-month project for my board and don't really have the time right now.

[Xenon]

I've coded an Archivehack long time ago, which could help :)

[scotty]

hm - I would prefer a sollution like wet wired mentioned...

xenon - your hack is great, but I have to convert 'bout 600.000 posts and this would last a long time.
I have no problem with database-space - my problem is the big search index.

an db-archive feature could be like:
- seperate archive -forum / -thread / -post / -attachement / -poll / -pollvote / -searchindex tabels
- moving threads form live to archive and back
- no posting in archive threads possible
- parameters for "makearchive.php" to be accessable via cron

advantage:
- moving threads form live to archive could be done very quickly
- archived thread use still the same fast engine for display
- search index is splitted and therefore each is much smaller
- t.b.c.

hm - can you follow me?

scott

[scotty]

*smile* has someone an idea?

[Xenon]

well it's not so easy to do as it seems to be.

i don't think anyone would do that for free, especially not when vb3 is so near so just everything will change...

[scotty]

is the db-concept for the searches in vb3 much different?

[Xenon]

i don't know.
i just know they have changed nearly every table and so i think the search engine has also changed a lot.

we have to wait for the public beta to see the exact changes..

[scotty]

thx for the info!