08-12-2015, 07:11 AM
...and individual count to each inferno difficulty, imagine seeing counter 499, then you switch to ridiculously high inferno difficulty to get possibly better card drop.
Now we count... there are 170 zones, 1000 inferno difficulty levels... that's 170000 counters per player.
Integer fitting the range 0-500 (best case scenario in inferno levels) must use 9 bits. Databases write data in whole bytes (8 bits). So we have to use 2 bytes per counter (smallint).
2 bytes per counter * 170000 counters per player = 340000 bytes per player.
It doesn't seem like a lot at a first glance, but it's a lot of wasted space when we count in the growing number of players. 3K players is about a gigabyte of data containing counters for each zone and inferno level. That is totally dumb.
Let's stick with random chance.
Now we count... there are 170 zones, 1000 inferno difficulty levels... that's 170000 counters per player.
Integer fitting the range 0-500 (best case scenario in inferno levels) must use 9 bits. Databases write data in whole bytes (8 bits). So we have to use 2 bytes per counter (smallint).
2 bytes per counter * 170000 counters per player = 340000 bytes per player.
It doesn't seem like a lot at a first glance, but it's a lot of wasted space when we count in the growing number of players. 3K players is about a gigabyte of data containing counters for each zone and inferno level. That is totally dumb.
Let's stick with random chance.