here is a fun game. estimate the size of the asteroids database.

my estimate: 9 megabytes.

9.1 megabytes

One dollar, Bob.

6.1 MB

hmm. too low so far. there are over 250000 asteroids in the database, and the information is stored rather generically (it's not just for asteroids)

im guessin 30 or 40mb

nah.... 50-70 mb. maybe even 100mb.

1 gig :D

I dont think that 4 mb for every asteroid can be considered to be much, or am I wrong... ?

417 MB just a wild guess

250000 'roids...
per astroid, lets see...
system - unsigned tinyint (1 byte)
sector - unsigned tinyint (1 byte)
x, y, z - integer (3x4 bytes = 12 bytes)
temperature - smallint (2 bytes)

I doubd they made more then 65000 different 'roid shapes
shape - smallint (2 bytes)

composition... I'd make a separate table of predefined compositions, size of that one can be neglected.
composition - smallint (2 bytes)

that's 20 bytes per roid, nice fixed rowsize, fast on the database.
250k roids makes 5Mb... but a1k0n said it's bigger ten 100, so they didn't optimise that hard :D

Even if we make the coords bigints (3x8bytes) it would only be 8MB and if we add a rotation speed in the same precision it would only make 14MB. Add indices on the location, maybe 20MB.

I didn't count geometry data for those 65000 different roids, but that can't be more then the game download of 110MB :D

So they're storing it rather differently, and as it's not just for astroids, it all depends on what else they put in those tables...

System and Sector are the same thing. Sol II A1 for example is known to the system as sector 0001. Right up to sector 7680.

112mb. <- its a guessing game right?

I never said it was more than 100 megs. It isn't.

In the case of a generic database lets multiply my guess by 10

61MB

1 dollor Bob. (wait for laughter...)

I guess 58meg.

Now that two people have made the same joke, I finally get it.

Come on down!

would guess about 24 meg :)

have fun

"temperature - smallint (2 bytes)"

this was proven wrong last night.

it also crashed the server. when is this horrible bug going to be fixed?

Right, in the reply screen the posts are sorted in reverse order... I thought your reply came after Celkans post :D

About (but not exactly) 31.4159265 MiB.

I don't get the One Dollar, Bob joke, even after googleing...