Archive Feature

[Ran Yefet]

Hello,

My name is Ran & I'm a Developer.
I have a very large forum with over 3 million posts. (Link)
Currently I'm using IPB version 2.3 but I'm planned to upgrade to 3.1.

One missing feature that I really need is archiving.

I saw that Charles mentioned (in [url=" topic) that archiving was planed for 3.1 but there's still no new about it.

Anyway what really important about the archive is that the topics and posts will still be access-able trough the Search, User Profile (Find my content), and the Actual Forum.

I've already planned how the archive feature will work, It'll be something like that:

At first i though to move the posts to another database but it'll be too complicated to implant the search and user post count.
The solution i found is that.

Creating another 2 tables in the IPB DB with the same structure as ibf_posts & ibf_topics that will be called
ibf_posts_archive & ibf_topics_archive

In the Admin Panel you could enable/disable which specific forum will have archive feature and which topics & posts will move to archive.

Manually: Move All Topics & Posts that Created before January 1st 2009.
Automatically: Move All Topics & Posts that a they are 1 Year Old.

Of course there will be a check box for "Include Pinned Topics?"

If a forum set the archive feature On that this button will show up:


The Global Search Option will look like this:


And the User Content will look like this:


To save the old topics urls for SEO all there need to do Is first check if the topic id is in the ibf_topics and if not do another check in the ibf_topics_archive.

I really thinks is the best way and less complicated solution for this problem.
This way all the old content will still be search-able and access able and it'll reduce the load from the ibf_topics & ibf_posts table.

I'll hope you will add this feature to version 3.2 It'll really help for the bigger forums.

Thanks.

[Mark]

It's still on our to do list :)

[Ran Yefet]

I'm glad to here that!

[Bob_Dobalena]

How is everyone getting above 400,000+ posts? 4gig limit has been killing my database (mysql), crashing and locking stuff. I have had to constantly prune to avoid it. Is there a trick I'm missing? :unsure:

[bfarber]

How is everyone getting above 400,000+ posts? 4gig limit has been killing my database (mysql), crashing and locking stuff. I have had to constantly prune to avoid it. Is there a trick I'm missing? :unsure:

Yes, there's a way to overcome the 4GB limit.

http://jeremy.zawodny.com/blog/archives/000796.html

[Ran Yefet]

a year later, still no updates regarding this issue which is really disappointing.
It's the only thing i'm waiting for in order to upgrade my forum.

Any news?

[bfarber]

No, otherwise we would have announced it. It's *still* on our to-do list, but it didn't make 3.2.

[Dmacleo]

to be honest I used the previous trashcan function for that.
not elegant but did help.