how many gigs are the AT forums database?

[OS]

Just curious.

 

[Aves]

Somewhere around 10GB I think, not quite sure.

I do remember Zuni once saying that they have had months with over 2500GB of data transferred. Sorry I couldn't be more helpful.

 

[Lithium381]

Originally posted by: aves2k
Somewhere around 10GB I think, not quite sure.

I do remember Zuni once saying that they have had months with over 2500GB of data transferred. Sorry I couldn't be more helpful.

only 10?!?!?! or 100 sounds more logical

 

[UglyCasanova]

Originally posted by: Lithium381

Originally posted by: aves2k
Somewhere around 10GB I think, not quite sure.

I do remember Zuni once saying that they have had months with over 2500GB of data transferred. Sorry I couldn't be more helpful.

only 10?!?!?! or 100 sounds more logical

It's all just text though.

 

[chiwawa626]

heh 10gb? i have more porn than that!

 

[Thegonagle]

Yeah, 10 GB is a lot of text!

 

[chiwawa626]

1 Byte = 1 letter or number
1024 Bytes = 1024 letters or numbers (1 Kilobyte Kb)
1024 Kb = 1 Megabyte (Mb)
1024 Mbs = 1 Gigabyte (GB)


10gb = a lot of letters/numbers

 

[HappyFace]

10GB = 10,737,418,240 characters! :Q

Buncha Nefs!

 

[d33pt]

i dont think it's even 10gb...i think it's more like 1...

 

[Shockwave]

Originally posted by: chiwawa626
1 Byte = 1 letter or number
1024 Bytes = 1024 letters or numbers (1 Kilobyte Kb)
1024 Kb = 1 Megabyte (Mb)
1024 Mbs = 1 Gigabyte (GB)


10gb = a lot of letters/numbers

What about smilies and frowns and stuff? And extra code for formatting and headers and whatnot. And avatars or whatever. And PM's.

 

[UglyCasanova]

Originally posted by: Shockwave

Originally posted by: chiwawa626
1 Byte = 1 letter or number
1024 Bytes = 1024 letters or numbers (1 Kilobyte Kb)
1024 Kb = 1 Megabyte (Mb)
1024 Mbs = 1 Gigabyte (GB)


10gb = a lot of letters/numbers

What about smilies and frowns and stuff? And extra code for formatting and headers and whatnot. And avatars or whatever. And PM's.

Even so, 10gb should be plenty for that.

 

[notfred]

Originally posted by: Shockwave

Originally posted by: chiwawa626
1 Byte = 1 letter or number
1024 Bytes = 1024 letters or numbers (1 Kilobyte Kb)
1024 Kb = 1 Megabyte (Mb)
1024 Mbs = 1 Gigabyte (GB)


10gb = a lot of letters/numbers

What about smilies and frowns and stuff? And extra code for formatting and headers and whatnot. And avatars or whatever. And PM's.

A smilie is 2 characters, a : and a ). Extra code for formatting headers and stuff is like [ q ] with no spaces. Each user gets a short string with an avatar, something like "eagle.gif". None of those take much space. PMs on there are the only thing with any significant data.

 

[HappyFace]

Lemme see here, if it's true that the AT forums transfer over 2500GB, we're talking the equivelent to 2,684,354,560,000 (over 2.5 trillion characters! whoa...)

 

[CTho9305]

Originally posted by: notfred
Each user gets a short string with an avatar, something like "eagle.gif". None of those take much space. PMs on there are the only thing with any significant data.

I would have a table of avatars, and each user get a 1-byte entry for the ID of the avatar. even smaller, though it requires an extra join

 

[Yomicron]

from here. This article was from 19 June 2002.

The final database is the Forums DB, which is by far the most transaction intensive database in the AnandTech Network. While the vast majority of the requests to the DB are in the form of selects (users reading categories and threads), there are significantly more inserts and updates (posting, thread/post counts, etc?) than in either of the other DBs. This database is also our largest, weighing in at just under 3GB during the testing and close to 8GB today (we used an older version of the DB from a few months ago).

 

[notfred]

Originally posted by: CTho9305

Originally posted by: notfred
Each user gets a short string with an avatar, something like "eagle.gif". None of those take much space. PMs on there are the only thing with any significant data.

I would have a table of avatars, and each user get a 1-byte entry for the ID of the avatar. even smaller, though it requires an extra join

Yours is smaller, mine is faster. It's a classic trade off.

Edit: what if you want to have more than 256 avatars?

 

[Aves]

Originally posted by: Shockwave
What about smilies and frowns and stuff? And extra code for formatting and headers and whatnot. And avatars or whatever. And PM's.

Smiles, avatars, etc are most likely not part of the database. PMs are part of it but probably don't account for much, 1 or 2 GBs most likely.

 

[aphex]

Im gonna venture a guess somewhere around 11 terrabytes.

 

[Shockwave]

So I guess its our duty to fill it up as quickly as possible. You know they want to upgrade, but cant justify it yet. Well, its our JOB to make sure they can do what they want!!
So, git to typin people! AT wants, no, needs hardware updates!!

 

[manly]

Originally posted by: notfred

Originally posted by: CTho9305

Originally posted by: notfred
Each user gets a short string with an avatar, something like "eagle.gif". None of those take much space. PMs on there are the only thing with any significant data.

I would have a table of avatars, and each user get a 1-byte entry for the ID of the avatar. even smaller, though it requires an extra join

Yours is smaller, mine is faster. It's a classic trade off.

Edit: what if you want to have more than 256 avatars?

Wrong, storing 'eagle.gif' 100,000 times for each row in the members table is silly. I have no idea how it's implemented in FuseTalk though.

 

[DanTMWTMP]

Originally posted by: chiwawa626
heh 10gb? i have more porn than that!

ahhah yeah 10 gigs is a crapload of text...aha seems right to me too...

 

[wolf550e]

November 18th, 2002: 10GB

 

[Codewiz]

Originally posted by: wolf550e
November 18th, 2002: 10GB

I guess most of you guys don't know anything about databases. It isn't just the data that takes up space. Hell I have a database that is 200megs without all that much data in it. Of course it is a crappy Access database but nonetheless.

I am betting that the database for the forums which is 10gigs uncompressed could be zipped up to about 1gig. Databases are usually highly compressable but grow in size pretty quickly to enable quicker data access.