09.04.2017, 10:44
That's not the point. Of course there's a lot of data. You're just not storing it properly. Anything that is not directly related to the player and anything that doesn't apply to all players should not be stored in the player table. Storing a lot of zeros and nulls is pointless and a waste of space. In general I wouldn't even go over 30 columns (yes, 30 not 300) columns for a single table.
This is a datamodel that I've drawn up in about 5 minutes and it shows how elaborate even a simple system can already be. Don't try to store everything in one or two tables because it's not going to work out and you're only going to limit yourself.
This is a datamodel that I've drawn up in about 5 minutes and it shows how elaborate even a simple system can already be. Don't try to store everything in one or two tables because it's not going to work out and you're only going to limit yourself.