Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Feb 2014, 07:39
dacho's Avatar
dacho dacho is offline
 
Join Date: Dec 2004
Real name: David
Need your help please with an idea about old and big database

Hi bro

I need your help with the subject of how to improve legacy/large forums systems and cleanse the forum

Most of us have a veteran forum with a lot of posts indexed in Google.
I think it's not right for us to delete them. (the old posts)
But the database is passing the size of 15 gigabytes, maybe there is a way to split it into two databases... or to do something else

Just an idea I do not know if I can apply it
Example:
1. Old data base (kind of archive) with all the messages of over a year without comments.
2. Active data base for all the new posts (Max from the last year).

Does anyone have an idea how to handle it?
If the idea to divide it into two databases true at all?
Is it possible to do with vBulletin?
You know a good way to do this?

I would love to have your help and your opinion

Thanks :)

Last edited by dacho; 20 Feb 2014 at 12:31.
Reply With Quote
  #2  
Old 19 Feb 2014, 11:20
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
I am not sure about database splitting it may not be possible .... but if your attachments,avatars etc are in the database then you can move them into filesystem to reduce the size of database.

Last edited by Seven Skins; 19 Feb 2014 at 11:29. Reason: Typo
Reply With Quote
  #3  
Old 19 Feb 2014, 12:33
dacho's Avatar
dacho dacho is offline
 
Join Date: Dec 2004
Real name: David
It's not about the attachments,avatars... etc
all my attachments save as file
Reply With Quote
  #4  
Old 20 Feb 2014, 17:08
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
I've complained for ages that what's needed is an archiving option when pruning forums. Right now all you can do is delete old posts. What would be great would be to append to a text file(s). I've been told the Print function already has half the work done.

You would be free to link to the text file thus preserving search engine access also.

My own current db daily backups are about 2gb, so I can't imagine how long it must take you to download those 15gb monsters.
Reply With Quote
  #5  
Old 23 Feb 2014, 06:16
dacho's Avatar
dacho dacho is offline
 
Join Date: Dec 2004
Real name: David
Delete old issues will have very bad for SEO, this amount of 404 I do not think that Google will like it.
Unfortunate that vbulletin is not thought a step further...
What happens when the big system begins to be and old
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 21:02.

Layout Options | Width: Wide Color: