How big is the database? / How big is yours?

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.
User avatar
Registered User
Posts: 706
Joined: Fri Jul 12, 2002 12:35 pm

How big is the database? / How big is yours?

Post by cdkrg »

Out of curiosity how big is the database right now? I'm trying to get a feel for how much space I'll need on my database.

I'd also like to know how big other people's databases are, if you give the size please also tell how many users and posts you have.
User avatar
Registered User
Posts: 33
Joined: Tue Apr 09, 2002 11:21 am
Location: Hesinki, Finland

Post by sasalone »

Number of posts: 30391
Number of topics: 4592
Number of users: 771
Database size: 49.62 MB
User avatar
Registered User
Posts: 5236
Joined: Fri Dec 07, 2001 2:39 pm
Location: Yorkshire, UK

Post by Daz »


Number of posts: 5448
Number of topics: 986
Number of users: 465
Database size: 6.63 MB

The phpBB database size has been posted a couple of times.
Please and Thank You works wonders...
I reserve the right to post illogical (and totally wrong) replies.
...It's the subtle perfection in attention to detail that makes your work rock the way it does - cdkrg
Think simple - it's not necessarily what you draw that matters, it's what you perceive - Daz

Note: ForumImages<dot>com is no longer anything to do with me.
Registered User
Posts: 506
Joined: Fri May 03, 2002 12:27 am
Location: Australia

Post by gatty »

Posts: 8846
Topics: 1126
Users: 541
Size: 9.48 MB

Free Hosting With PHP/MySQL Support!

Image Search Before Asking!
R. U. Serious
Registered User
Posts: 830
Joined: Mon Feb 11, 2002 2:07 pm

Post by R. U. Serious »

Posts: 7300
Topics: 770
Users: 290
DB-Size: 7.17MB

Posts: 8320
Topics: 550
Users: 292
DB-Size: 10,5 MB
User avatar
Registered User
Posts: 706
Joined: Fri Jul 12, 2002 12:35 pm

Post by cdkrg »

An average of 724 posts per MB.

Not very exact since I don't consider the non posts DB space but this is helping me get a rough idea (very rough since eaxh forum will have a different average post size).

Keep em coming! Thanks to all who have posted.
User avatar
Former Team Member
Posts: 4032
Joined: Wed Jan 16, 2002 7:05 am
Location: Seattle, WA, US

Post by chAos »

the's database last time it was posted, i think was around 90mb.
Registered User
Posts: 20
Joined: Fri Oct 11, 2002 1:09 am

Post by siq604 »

Number of posts: 4517
Number of topics: 540
Number of users: 112
Board started: 30 Aug 2002
Database size: 2.50 MB

Why is my DB so small compared to other users? What affects DB size the most? Is it # of users/posts/topics? - check it out yo!
Registered User
Posts: 20
Joined: Tue Mar 12, 2002 2:07 am

Post by cabbage »

Number of posts: 7133
Number of topics: 843
Number of users: 338
Board started: 09 Mar 2002
Database size: 6.70 MB

That's for an official web site for an Island/Def Jam band
User avatar
Registered User
Posts: 706
Joined: Fri Jul 12, 2002 12:35 pm

Post by cdkrg »


46 members

1223 posts

12.5 MB (lots of big posts)
Registered User
Posts: 38
Joined: Wed Jun 12, 2002 2:56 am
Location: Orlando, FL

Post by GLJones »

Mine doesn't list the size, it's N/A.

Is this an ISP thing or a problem?

Registered User
Posts: 6
Joined: Tue Jan 15, 2002 2:32 am
Location: Tampa, Fl

Post by Aharon »

Number of posts 308715
Posts per day 353.42
Number of topics 31528
Topics per day 36.09
Number of users 3782
New Users per day 4.33
Board started 01 Jun 2000 08:00 pm
Board Up Days 873.52

Database size 151.78 MB
Registered User
Posts: 151
Joined: Fri Dec 21, 2001 1:05 am
Location: Canada

Post by Sheps »

Number of posts: 5689
Posts per day: 18.81
Number of topics: 480
Topics per day: 1.59
Number of users: 253
Users per day: 0.84
Board started: Mon Dec 24, 2001 10:25 pm
Avatar directory size: 210.09 KB
Database size: 8.87 MB
Gzip compression: OFF

Mosat of my people do oneline spammers

User avatar
Former Team Member
Posts: 3633
Joined: Tue Sep 25, 2001 7:23 pm
Location: Kµlt °ƒ Ø, working on my time machine

Post by TC »

here's my astonishing statistics:
the funnel wrote: Number of posts 1809
Number of topics 585
Number of users 38
Database size 4.47 MB
Avatar directory size 29.46 KB
Most Users Ever Online 29
Gzip compression Enabled

and the most amusing stat of all:
Top Posting User - TC 863 48%

.:: 28:Ø6:42:12 ::.
Registered User
Posts: 132
Joined: Sat Oct 06, 2001 5:12 pm
Location: Holland

Post by Presto »

IDP FORUM (dutch DJ forum)

Posts: 52020
Topics: 3041
Users: 560 (over 1000 but pruning not active users every week)
Board started: 12 Dec 2001 08:00
Avatar directory size: 1.38 MB
Database size: 48.17 MB

Return to “2.0.x Discussion”