miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
The Other miniBB Support Forums / The Other /   

Forum Archives?

Page  Page 2 of 2:  « Previous  1  2  
Author Ivan
Advanced Member
#16 | Posted: 17 Sep 2006 17:20 
Ah, yes, and it will be better, more compact, more secure and... most cosy :) - one or two databases with all the stuff in, instead of thousands of pages. Including the case of moving the board, if needed. Like a suitcase :) Very fine! :)

Author Moony
Registered
#17 | Posted: 17 Sep 2006 18:33 
Whatever is the idea there should be possibility to switch off archiving all together for those who can afford having BIG databases.

Author Ivan
Advanced Member
#18 | Posted: 17 Sep 2006 20:38 
However, the DB is quite smaller than HTML, and 50-100 MB is very big thing, much text. The other elements in your site will ask much more room - photos, HTML, other pictures, music...

The lowest hosting at my provider is 333 MB, I have 2 GB for about 100 Euros/year. Year, not month. The other hostings are similar. So? :)

Author tom322
Registered
#19 | Posted: 17 Sep 2006 20:59 
I think the most important question is how many users are on your website at the same time (so how many database connection they create at the same time)... While you can physically have 500mb as database, it will work proportinally slow to the database requests at the same time...

Author Paul
Lead Developer
#20 | Posted: 18 Sep 2006 07:12 | Edited by: Paul 
I think the most important question is how many users are on your website at the same time (so how many database connection they create at the same time) - I would suppose this is the most right opinion from the above said. We need archiving feature, if for example, your forums contain about 200,000 posts and they begin to work slower (for some reason - but hardware is the first!), specially Search feature or Latest Discussions. In that case, we need to create SEPARATE tables, so old data is moved from the "main" tables, which will be executed much more often than archived tables. For example, if we have for main tables

minibbtable_topics
minibbtable_posts

then for the archived stuff, we will have

minibbtable_topics_2006
minibbtable_posts_2006

Brazilian forums mentioned do not use the stuff like described. All posts are still saved in the same tables, I asked Sam sometimes about that stuff, and he replied this is just mod_rewrite + some easy script thing. Nothing complicated, but nothing also related to "real" archives.

Anyway, with miniBB's fast engine, it's not urgent to create such kind of archives, so we are not hurrying with that feature. As you see, million-posts forums are running ok, because they are on a powerful dedicated server and good line; forums at radioscanner.ru which I develop, are expecting thousands of visits daily and contain more than 150,000 open posts, but they are still running very good on a virtual hosting, and they all contain the same functions as default miniBB (despite they are "advanced" with additional features a lot).

So this is just the question of good hardware, good connection and good moderation. We on miniBB.com are going to re-arrange our own forums, remove old necessary posts completely, because it should be done once per 2-3 years, if you carry about the content.

Page  Page 2 of 2:  « Previous  1  2 
The Other miniBB Support Forums / The Other / Forum Archives? Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB