(real) Archiv for vBulletin 3

[scotty]

I'm looking for an hack like that one from Xenon:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=39104

why? I would like to have the achived threads/posts in another tables than the actual threads/posts for (search-) performance reasons.

there is no need for compressing the data - just move in another tables with no posting funktion inside.

any ideas?

THX,
sotty

[scotty]

*bump*

none? :(

[colicab-d]

why not modify one of the vbulletin files, i.e the admin .php that is used to move threads :) set up a new set of tables and mdify the .php to use them instead then you could maybe achieve it that way, soz for the crap reply but im no php expert.

[scotty]

why not modify one of the vbulletin files, i.e the admin .php that is used to move threads :)
that function will only "move" the threads from one forum to another; means, that the forumid in the db-row of that thread is changed.
but no moving of postings will take place... :(

i'll look into the vb2 code of Xenon the next few days, maybe i get an idea...

[AN-net]

so you want to be them to a completely different table after such a period of time?

[Serge]

hmm I might try if no one else is. Basically you want it so you can move threads to a completely different set of tables that are more or less stripped down versions of the thread and post tables vbulletin uses. Then a script like archive.php that displays the threads and lets you read them as well?

EDIT: Also reading though the thread a bit more do you want it to do this after a certain amount of time or do you want it to happen manually.

[scotty]

so you want to be them to a completely different table
yepp!

different thread/post tables for perfomance reason...

[scotty]

hmm I might try if no one else is.
that would be great! :)

Basically you want it so you can move threads to a completely different set of tables that are more or less stripped down versions of the thread and post tables vbulletin uses.
yes

Then a script like archive.php that displays the threads and lets you read them as well?
correct.

the reason is the following: huge forums like mine get performance problems when searching the big post table.
my archive has about 2 million postings. i won't prune it, so look for a posibillity to "archive" it.

EDIT: Also reading though the thread a bit more do you want it to do this after a certain amount of time or do you want it to happen manually.
i prefer the manual way: select a bunch of threads like in the "move threads" option in CP and the chosse "archive", with the option "keep original threads" or prune it.

the archive don't have to be compressed like in Xenons hack, because that would cost to much performance when moving.

thx in advance! :)

if you have questions...

scotty

[Xenon]

that function will only "move" the threads from one forum to another; means, that the forumid in the db-row of that thread is changed.
but no moving of postings will take place... :(

i'll look into the vb2 code of Xenon the next few days, maybe i get an idea...
Feel free to do so, but for vb3 it's not that easy anymore, regarding that damn threaded mode ;)

As for the compression thing: the compression doesn't cost that much performance, the more intesne thing is to remove the old thread from the DB, because the searchindex has to be updated, and that's the real intense thing...

[scotty]

As for the compression thing: the compression doesn't cost that much performance, the more intesne thing is to remove the old thread from the DB, because the searchindex has to be updated, and that's the real intense thing...
that means: if you have the mysql4 fulltext search enabled, the transfer would be much faster?

threaded mode isn't such a big problem for me... it's disabled in my forum, cause of the (normal) size of my threads... there are too big.

scotty

[Xenon]

hmm, i don't know the speed of mysql's full text seraching indexing, but i think so, as it should be strongly optimized ;)

but generally yes, it should be much faster when you are using mysqls fulltext indexing instead of vb's

[scotty]

short note: I've just finished archiving about 2.600.000 postings in my board. I'll have to make some further compatibility test, than I will release it as hack.
it's another approach, then used by Xenon, and the result is a dramatic increase of speed by reducing the "post"-table by half... :)
...so the "key feature" of my hack is speed improvment for large boards (> 1 million posts), and not to reduce used space.

I hope, I get the beta released in about 2 weeks!

scotty

[Brains]

Very interesting to me indeed. I'm only at 2.1 million posts, but we keep them *all* online and searchable at all times. I've since moved search to an alternate slave mysql server to keep from killing site performance, and I'm sure this would help all that much more.