Mysql storage advice
Posted: Mon Mar 12, 2012 9:23 am
Hello all,
As part of a university project i am making an online browser based multi player game. The theme of which is a sports management game.
I am currently in the planning phase and have come across a little problem in terms with how to best save team player profiles.
I plan on having 200-300 team player profiles that are allocated to a number of teams. The amount of player profiles however may increase into the thousands.
How would you best advice saving these profiles in a database?
My options are to save all player profiles and their relevant stats into one table, or split them into multiple "team based" tables so each team has their own table of players.
I am just after which method will serve me the quickest results really. I should mention that at certain points of a day i will have cron jobs running altering each player's stats so it would need to go into each table if they were seperate.
Would having a couple thousand records in one table cause slowness if u wanted just a random 30 say ?
Many Thanks in advance
As part of a university project i am making an online browser based multi player game. The theme of which is a sports management game.
I am currently in the planning phase and have come across a little problem in terms with how to best save team player profiles.
I plan on having 200-300 team player profiles that are allocated to a number of teams. The amount of player profiles however may increase into the thousands.
How would you best advice saving these profiles in a database?
My options are to save all player profiles and their relevant stats into one table, or split them into multiple "team based" tables so each team has their own table of players.
I am just after which method will serve me the quickest results really. I should mention that at certain points of a day i will have cron jobs running altering each player's stats so it would need to go into each table if they were seperate.
Would having a couple thousand records in one table cause slowness if u wanted just a random 30 say ?
Many Thanks in advance