Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - How large is your Web Wiz db?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How large is your Web Wiz db?

 Post Reply Post Reply
Author
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post Topic: How large is your Web Wiz db?
    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!

Edited by JohnKn
Back to Top
Flamewave View Drop Down
Senior Member
Senior Member
Avatar

Joined: 19 June 2002
Location: United States
Status: Offline
Points: 376
Post Options Post Options   Thanks (0) Thanks(0)   Quote Flamewave Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Nigelo View Drop Down
Groupie
Groupie


Joined: 11 October 2002
Location: United Kingdom
Status: Offline
Points: 67
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nigelo Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Nigelo View Drop Down
Groupie
Groupie


Joined: 11 October 2002
Location: United Kingdom
Status: Offline
Points: 67
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nigelo Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.