How large is your Web Wiz db?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1256
Printed Date: 29 March 2026 at 4:21am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: How large is your Web Wiz db?
Posted By: JohnKn
Subject: How large is your Web Wiz db?
Date Posted: 22 March 2003 at 11:36pm
|
I've been using another forum script (sorry, I had it up and running before finding Web Wiz!) and was wondering how it's db size compared to that of Web Wiz using Access 2000.
Currently my forum is at: 4,880k 382 members 4 categories 11 forums 837 threads 6,593 posts. How does that compare to an active Web Wiz forum? Inquiring minds want to know! 
|
Replies:
Posted By: Flamewave
Date Posted: 24 March 2003 at 1:49am
|
The forum on one of the websites that I run (v 6.34) has this: DB size: 1.75 MB I'm sure if I downloaded the database and did a compact and repair on it it would be somewhere around 1.2 MB. Hope that helps. ------------- - Flamewave They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides. |
Posted By: Nigelo
Date Posted: 24 March 2003 at 3:30pm
|
Sorry to sound negative but how long is a piece of string? Don't you Guys realise that the "Posts" table (actually tblThreads) uses a field of the Memo type (for the Post Body) which our colleagues at MS define as follows:
It should therefore be apparent that the Database size will be substantially influenced by the length of each post and the degree of formatting used. Basically, what I am saying is that DB size is dependent on the data stored within it. Borg's DB design is very well executed (ie normalised) and is therefore very efficient on size assuming you regularly run a compact. ------------- Hope this helps Nigel |
Posted By: JohnKn
Date Posted: 24 March 2003 at 3:43pm
|
You're correct the size of the db will depend on the size of the posts, but once you have several thousand posts you can predict db growth in the future. I would bet that if you compared Web Wiz databases with 10,000 posts from two different sites that they would be very nearly the same size.
Every forum doesn't store or track the same data so you can't say that because forum X has 10,000 posts and has a 6 meg db that forum Y will have the same stats. I wasn't insulting Borgs forum, just asking a straight forward question. |
Posted By: Nigelo
Date Posted: 24 March 2003 at 6:48pm
|
I wasn't suggesting that you were insulting Borg's forum and I thought I had given you a straight forward explanation as to why your question was off centre. Put differently, two different Forum Applications, both based on an Access DB and using identical data, would be similarly sized assuming they are both properly designed in the first place. What takes up most of the space for a Forum App is the memo field for the guts of a post - Think about it. ------------- Hope this helps Nigel |