I find this easier for readability having all the user's stats across a single row. I like it that I ask for a single row and I have all the player's stats.
In all honesty I consider you a far better judge than me on database handling and sql. This has been my first attempt at a large DB (currently over 1.2 million player stats stored) and so far it's been hassle free, but I have no previous experience to compare to.
I'm not confident enough to recommend one layout over the other, all I can say is what works for me.
Edit: Please lemme know what way you go, and how it goes. I'm sure no matter what you do it will work out well
07-Feb-2014 22:43:00
- Last edited on
07-Feb-2014 22:47:15
by
Indecent Act
I feel like the 2nd option would lead to more concise code, but I think it's a little slower, cuz you'd have to run multiple queries every time you update it.