I'm building an inventory system for a MMORPG game that can possibly contain massive numbers of players (~20.000). Is it smart to make an InventoryTable where each row contains only one item, or should I make one big VarChar column that contains all of the information about all Items for a player.
A player has about 200 items.
And every item has about 20 additional pieces of information:
ItemID, Amount, ...
So this big varchar column can be something like 15000 chars long.
Here are some basic attributes:
What will be faster?
- Reading maybe 200 lines from a big table for each player
- Or one big line for every player and serialize it in my server.
Is use a MSSQL database with ODBC.