[dev1357] The Armoire

[Asiaine]

mh. Let's look at this example

- item id: 32 bit uint (room for 4,294,967,295 unique items)
- spiritbind status: 8 bit unsigned short (values from 0 to 255)
- repair condition: another 8 bit unsigned short

makes a total of 48bit per item. We have about what, 100 items currently storable in the armoire?
That means it makes 480bit, or 60byte of additional data per character.

If we assume we have about 200 000 players (which we don't), we have ... 12 000 000 byte of additional storage.
That's 11 718kbyte. Which is 11.4 Mbyte of additional space used for the ENTIRE population

tl;dr: space is definitely not an issue.

*sigh*

You leave out many of the important things, it is sad. I hope people who read this can try to understand that SE probably hires people who actually have some experience with databases and storage... should I mention a few of the things you left out?

-- Journaling
-- Indexing
-- Backup
-- Memory utilizing
-- File Cluster Size
-- Failover
-- Distributed/Simultaneous access overhead

Should we discuss performance? Forward compatibility?

I implore everyone: Unless you've seen the code, don't comment on the code.