How big is the pistonheads database?

[mikezs]

I was wondering: just how big is the posts table of the pistonheads database?

[TonyHetherington]

151 forums contain 13.1 million posts

13.1million and 2
13.1million and 3



(very easy to see....just click the "gassing" bit at the top of this bit you're reading and you can see the post numbers of each forum)

[mikezs]

Was hoping for a value in GB from one of the admins

[Mr Will]

Probably not as big as you'd think, the entire database currently weighs in around the 90gb mark, but that includes quite a few logs, the search data and other large files which will account for a good chunk of that.

[mikezs]

Mr Will said:

Probably not as big as you'd think, the entire database currently weighs in around the 90gb mark, but that includes quite a few logs, the search data and other large files which will account for a good chunk of that.

That is smaller than I would have expected! Any details on server specs?

[Vixpy1]

mikezs said:

Mr Will said:

Probably not as big as you'd think, the entire database currently weighs in around the 90gb mark, but that includes quite a few logs, the search data and other large files which will account for a good chunk of that.

That is smaller than I would have expected! Any details on server specs?

Just before they are upgraded for the millionth time - st

Just after they have been upgraded for the millionth time - slightly less st

[Mr Will]

mikezs said:

Mr Will said:

Probably not as big as you'd think, the entire database currently weighs in around the 90gb mark, but that includes quite a few logs, the search data and other large files which will account for a good chunk of that.

That is smaller than I would have expected! Any details on server specs?

You know the phrase "A picture is worth 1000 words", well it's very true in terms of PC disk space, and a video is 25 pictures per second.

Now that people have got used to storing large amounts of pictures and video on their PC's, it is easy to forget how much text you can cram into a comparatively small space.

With regard to servers, I don't want to go into too much detail but there are currently (IIRC) 14 different servers doing things in the live system, plus a few testing ones.