| |
| |
|
|
|
|
| |
|
| |
|
| :: |
| Author |
Message |
fabikus
Joined: 07 Oct 2006
Posts: 23
|
 Posted: Fri Dec 08, 2006 11:55 pm Post subject: Html archive of old messages |
|
|
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  |
|
|
| Back to top |
|
 |
|
|
dcz
Administrateur - Site Admin
Joined: 28 Apr 2006
Posts: 15131
|
| Posted: Sat Dec 09, 2006 10:37 am Post subject: Re: Html archive of old messages |
|
|
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 ?
++ |
_________________
Useful links :
SEO Forum || SEO Directory || SEO phpBB || SEO phpBB3 || Search
____________________
Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Référencement phpBB3 || Recherche |
|
| Back to top |
|
|
fabikus
Joined: 07 Oct 2006
Posts: 23
|
| Posted: Sat Dec 09, 2006 11:19 am Post subject: Re: Html archive of old messages |
|
|
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! |
|
|
| Back to top |
|
|
dcz
Administrateur - Site Admin
Joined: 28 Apr 2006
Posts: 15131
|
|
| Back to top |
|
|
fabikus
Joined: 07 Oct 2006
Posts: 23
|
| Posted: Sat Dec 09, 2006 7:11 pm Post subject: Re: Html archive of old messages |
|
|
| Quote: | | 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 |
|
|
| Back to top |
|
|
|
|
| Navigation |
Similar Topics |
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
