0

I am planning to create an online game where user moves in a random path. I need to keep track of current location of player in the map. Since there will many concurrent players that keep moving around, there will be too many values to keep track of.

I was wondering if I need to save the last accessed coordinates by player, is it better to keep a text file for each player that save a single location value, or save all players' locations in one database table?

I know this might seem like an old question, I have already checked similar questions in Stackoferflow, such as:

But in those questions the answers were broad and general. I need a specific answer: Single file per user and single value by file, is better than a single table for all users for very frequent update/read?

Community
  • 1
  • 1
Lamar
  • 1,761
  • 4
  • 24
  • 50
  • "Since there will many concurrent players that keep moving around, there will be too many values to keep track of." I would question the validity of this assertion. If there were a billion players, that would equate to a billion rows. An RDBMs can handle a billion rows. – Strawberry Jan 22 '17 at 12:56
  • To be realistic the game wouldn't reach that scale, I'd say few thousands tops. – Lamar Jan 22 '17 at 14:24
  • You can't even up technology inefficiencies (php, http) with clever persistence solution. – shudder Jan 22 '17 at 14:28

0 Answers0