Fog Creek Software
Discussion Board




How big is this boards database?

My last guess on the size of the database behind this forum was off by 45MB so I thought I'd try again (plus I'm bored atm).

http://discuss.fogcreek.com/joelonsoftware/default.asp?cmd=show&ixPost=88160&ixReplies=9

I guessed that it was 175MB and Joel said it was 130MB.

So going by the number Joel gave me and the stats over at:

http://www.usabilitymustdie.com/jos/WW_MonthlyStats.html

I think I can more accurately predict the size of the database.

130 MB * 1048576 Bytes/MB = 136314880 Bytes

78514 Posts as of November 19, 2003 / 136314880 Bytes Total as of (prev date) =

1736.18564 Bytes Per Post Average

1736 Bytes Per Post Average * 142,925 Posts of 12 July, 2004 - (Todays numbers aren't up.) =

248144332.597 Bytes Total /  1048576 Bytes/MB =

237 MB - That's my final answer.  (I'm not sure if it makes sense because that would mean that the DB grew by 107 MB in less than a year.)

Dave B.
Monday, July 19, 2004

don't you have better thing to do?


Monday, July 19, 2004

***I'm not sure if it makes sense because that would mean that the DB grew by 107 MB in less than a year.)***

Sounds like that's about the time Sathyaish Chakravarthy and muppet start posting.  So it does make sense.

:)
Monday, July 19, 2004

s/start/started

:(
Monday, July 19, 2004

I object to being lumped in with Sathyaish.

muppet
Monday, July 19, 2004

Yeah, you're not nearly as polite.

.
Monday, July 19, 2004

For one.

muppet
Monday, July 19, 2004

(I'm not sure if it makes sense because that would mean that the DB grew by 107 MB in less than a year.)

Why?  If you look at the total number of posts for each date, your numbers make sense.

Steamrolla
Monday, July 19, 2004

I think you should use the Post Numbers to get a more accurate total. If you don't you will be missing all the deleted spam and off-topic posts.

SO:

130 MB * 1048576 Bytes/MB = 136314880 Bytes

88,160 Posts as of November 19, 2003 / 136314880 Bytes
=

1546 Bytes Per Post Average

1546 Bytes Per Post Average * 164,841 Posts as of this thread =

254,844,186 Bytes Total /  1048576 Bytes/MB =

243 MB - That's *my* final answer. 

DJ
Monday, July 19, 2004

Where did you get the post numbers from DJ?

Dave B.
Monday, July 19, 2004

In every URL you will see ixPost=99999

I take it as a sequential ID number that gets incremented for each new post.

DJ
Monday, July 19, 2004

oic.

Well that's an interesting way of doing it.  If the off topic posts aren't deleted then that would make sense.  It seems that the first post (that we can see) started with an ixPost of 88.

http://discuss.fogcreek.com/joelonsoftware/default.asp?cmd=show&ixPost=88

Dave B.
Monday, July 19, 2004

Almost all of Joel's first forum posts are 88 or 188 or some deriviation of 88. I pointed this out at least a year ago & he still hasn't responded.

Another heuristic you can use is not going to usability must die, but looking at the # of the latest thread. This thread was started by post 164,841.

www.MarkTAW.com
Monday, July 19, 2004

130MB / 88160 = 0.0014745916515426497277676950998185

164841 * 0.0014745916515426497277676950998185 = 243.

So my number would be 243 as of the beginning of this thread.

www.MarkTAW.com
Monday, July 19, 2004

My JOS Statistics database is 202MB at the moment.

I will be publishing last weeks JOS stats tonight and I will also produce a chart that shows the number of words published on JOS from Oct 2001 to Jul 2004.

At the end of 2001 4,000 words were being added every day. At the moment around 30,000 words a day are being added. On 13 July 2004 43,632 words were added to JOS.

Chris McEvoy
Tuesday, July 20, 2004

Just to pick nits, Chris, do you count punctuation as words? That numbers seems pretty high.

.
Tuesday, July 20, 2004

No I don't count punctuation.

Here is the URL for the JOS Daily Words chart:

http://www.usabilitymustdie.com/jos/jos_daily_words.gif

Chris McEvoy
Tuesday, July 20, 2004

Out of curiousity, how does that words/day compare to posts/day? I.e. has the number of words-per-post gone up?

www.MarkTAW.com
Wednesday, July 21, 2004

I will post a corresponding "Number of Daily Posts" in a couple of hours.

Chris McEvoy
Wednesday, July 21, 2004

And here it is:
http://www.usabilitymustdie.com/jos/jos_daily_posts.gif

Chris McEvoy
Wednesday, July 21, 2004

*  Recent Topics

*  Fog Creek Home