09.02.2017, 05:02
Hello, everybody well i am working on my server right now and i am wondering what would be the smartest thing for me to do the statistics. As of know i am putting all player statistics, such as cash, bank money, fighting style etc. in Users table. In all i have 34 fields right now for the Users table. I am wondering now, is it worth just creating a different table for stats something similar to what a gun saving system looks like? So the stats table would include User ID, User nickname, stat ID and the statistic itself in there and that would be for every player. Or is it just better for me to keep on piling up on the User table, with amount of fields reaching almost 100 or more? And yes i have read, threads on database normalization, but just want some opinions on what is the best thing dealing with statistics. Thank you.