Hi all, i need to make smaller my database so i want to archive and delete old messages in my forum.
Is there a Search engine friendly mod to make an html archive of forums and then delete old messages?

Thanks in advance

Well, this could end up being a lot of work.

Not really to cache the pages, but to store them as they could be many.

You'd need one html file per topic page, and you would not have access to old post URL unless you add one more html page per post.

This could end up being impossible to deal with depending on the amount.

We could call a cache file from within php, for example base on the topic id, if it's smaller than the highest to have been cached, load the cache. The advantage would be to be able to even load (and why not redirect to topic) post url, but it's quite some code change. And all these cached page should thus be locked prior to cache, because they'd not be dynamic anymore.

Don't you have another option ?

Because all this could relieve the SQL server a bit, and Apache as well, for all the text parsing, but still, the more file the more work.

And it would only be a temporary measure, the only lasting strategy is to upgrade hosting and to optimize phpBB.
Did you know the phpBB tweaks for large forum thread ?

++

My idea was only to archive in html files old messages (for example all 2004 or 2005's messages) and then delete them. Like the pruning function of board...
For example vBulletin on http://www.vbulletin.com/forum/archive/index.php/ that has in archive only old messages.

I saw there is a phpBB Search Engine Indexer mod, but i think it is not what i need (he doesn't delete old messages, he just make an html archive taking threads from database).

My dedicate server is already good, i don't think i need a dual Opteron for my board...
However i don't know phpBB tweaks for large forum thread yet, i'll see!

It's exactly the same as phpBB Search Engine Indexer, look this post : http://www.vbulletin.com/forum/archive/ ... 11951.html

Dec 9th 2006, 10:43am

Same content coming from same DB.

So it's pseudo duplicate content, we talked about this here and here.

I am not sure it is this good.

A good idea would be to do kind of like you first suggested, only list deleted topics with this mod. This would require quite some coding, but, you could end up storing the messages in new tables, and maybe make phpBB working a bit faster.

++

A good idea would be to do kind of like you first suggested, only list deleted topics with this mod. This would require quite some coding, but, you could end up storing the messages in new tables, and maybe make phpBB working a bit faster.

Yes, this is a good idea