How big is your database?

The 2.0.x discussion forum has been locked; this will remain read-only. The 3.0.x discussion forum has been renamed phpBB Discussion.
Roger Moore
Registered User
Posts: 47
Joined: Sun Jan 27, 2002 1:59 pm

How big is your database?

Post by Roger Moore » Sat Mar 30, 2002 1:15 am

Please can you post below the size (in MB) of your MYSQL database and also how many members/posts you have.

I'm currently looking for a host and i'd like to know what sort of hosting plan is right for me.

Thanks,


Roger

eXplosive
Registered User
Posts: 368
Joined: Mon Mar 04, 2002 4:03 am
Contact:

Post by eXplosive » Sat Mar 30, 2002 1:24 am

My db size is 572KB. I have 102 members and 142 post.

User avatar
dieKetzer
Registered User
Posts: 33
Joined: Wed Oct 10, 2001 3:16 am
Location: melb au

Post by dieKetzer » Sat Mar 30, 2002 1:54 am

Posts: 10,287
topics: 1012
users: 235
database size: 3.69MB

IMO a smallish bbs needs at least 10MB of database storage to be safe.
If you don't plan on getting any larger than the size of my board I suppose 5MB could do if you enabled pruning though.
Also the number of members looks to have little effect on db size. Post count is the critical factor. Search functions also eat up a lot of db space (relational to number of posts as well).
Advise: Before signing up with a host be sure to check out what they charge for going over your allowed db storage (and server bandwidth) limit!

DC
Registered User
Posts: 48
Joined: Sat Jan 26, 2002 9:03 am
Location: MA
Contact:

Post by DC » Sat Mar 30, 2002 2:08 am

  • Number of posts: 4564
  • Posts per day: 61.74
  • Number of topics: 360
  • Topics per day: 4.87
  • Number of users: 82
  • Users per day: 1.11
  • Board started: 14 Jan 2002 22:48
  • Avatar directory size: 15.96 KB
  • Database size: 9.26 MB
  • Gzip compression: OFF
Many of our posts are very large. ;)

User avatar
chronos
Registered User
Posts: 25
Joined: Wed Mar 13, 2002 4:06 am
Location: Tulsa, OK
Contact:

Post by chronos » Sat Mar 30, 2002 2:24 am

Number of posts: 12177 Posts per day: 53.66
Number of topics: 903 Topics per day: 3.98
Number of users: 74 Users per day: 0.33
Board started: 14 Aug 2001 22:33 Avatar directory size: 119.19 KB
Database size: 7.72 MB Gzip compression: OFF
Chronos

mp3master
Registered User
Posts: 20
Joined: Thu Mar 07, 2002 5:37 am
Location: NYC
Contact:

Post by mp3master » Sat Mar 30, 2002 2:45 am

gosh, the size of my database is crap!!

it's 1.08 MB :(

is this normal?

User avatar
ThE-UnknowN
Registered User
Posts: 148
Joined: Wed Oct 10, 2001 8:23 am
Location: In your Computer
Contact:

Post by ThE-UnknowN » Sat Mar 30, 2002 8:34 am

Number of posts: 1042
Posts per day: 13.24
Number of topics: 70
Topics per day: 0.89
Number of users: 85
Users per day: 1.08
Database size: 1.75 MB

8)
http://www.chatvenue.com is finally taking shape.

Roger Moore
Registered User
Posts: 47
Joined: Sun Jan 27, 2002 1:59 pm

Post by Roger Moore » Sat Mar 30, 2002 9:27 am

Thanks a lot guys!



Roger

User avatar
Gophy
Registered User
Posts: 2
Joined: Mon Dec 24, 2001 10:15 pm

Post by Gophy » Sat Mar 30, 2002 1:56 pm

Number of posts: 19419
Posts per day: 203.14
Number of topics: 1047
Topics per day: 10.95
Number of users: 374
Database size: 14.49 MB

the users on my board tend to make quite big posts though ;)

eXplosive
Registered User
Posts: 368
Joined: Mon Mar 04, 2002 4:03 am
Contact:

Post by eXplosive » Sat Mar 30, 2002 2:19 pm

mp3master wrote: gosh, the size of my database is crap!!

it's 1.08 MB :(

is this normal?

Get some more post then you your size will increase.

DC
Registered User
Posts: 48
Joined: Sat Jan 26, 2002 9:03 am
Location: MA
Contact:

Post by DC » Sat Mar 30, 2002 6:32 pm

Gophy wrote: Number of posts: 19419
Posts per day: 203.14
Number of topics: 1047
Topics per day: 10.95
Number of users: 374
Database size: 14.49 MB

the users on my board tend to make quite big posts though ;)


Go look at my numbers posted above...the members on my board post very long messages. ;) You have 5 times the amount of posts and my DB size is close to yours. Maybe there is some useless data in my DB?

Matthijs
Former Team Member
Posts: 1031
Joined: Sat Dec 08, 2001 4:27 pm
Location: The Netherlands
Contact:

Post by Matthijs » Sat Mar 30, 2002 8:47 pm

Posts: 172280
Topics: 22546
Users: 7854
Words in search wordlist: 140442
Database size: 159.85 MB
phpBB Converter Team Member
Developer of the vBulletin 2.x.x -> phpBB 2.0.x Converter
See Matthijs.net for more info

User avatar
Gophy
Registered User
Posts: 2
Joined: Mon Dec 24, 2001 10:15 pm

Post by Gophy » Sat Mar 30, 2002 8:48 pm

DC wrote: [..]
Go look at my numbers posted above...the members on my board post very long messages. ;) You have 5 times the amount of posts and my DB size is close to yours. Maybe there is some useless data in my DB?


your board is for postaholics anonymous? ;)

chinch
Registered User
Posts: 169
Joined: Mon Mar 11, 2002 7:34 pm

Post by chinch » Sat Mar 30, 2002 10:32 pm

i imported a small portion of my board and members as i convert over to phpBB... here are some stats FWIW...

Number of posts: 45125
Number of topics: 3536
Number of users: 1451
Database size: 52.03 MB

t3mp14rX
Registered User
Posts: 6
Joined: Thu Mar 28, 2002 3:26 pm
Location: USA
Contact:

Post by t3mp14rX » Sat Mar 30, 2002 11:38 pm

Number of posts: 1
Number of topics: 1
Number of users: 2
Board started: 26 Mar 2002 10:37 am
Database size: 51.25 MB

I pay $35 for a kickass plan.
I get 50 megs of MSSQL space :D
Lots of room for growth.
-----\ t3mp14rX \-----
[ www.bluemist.org ]
-------------------------

Locked

Return to “2.0.x Discussion”