Print Page | Close Window

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
70 members
4 categories
10 forums
228 threads
1137 posts

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:

Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database.) 

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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net