I am developing a strategy war board game. Each player choses his soldiers from a database. I am aware that an online DB is needed for the game to keep track scoring. That's another issue.
The point is the soldiers DB has 500 entries, each soldier having 50 stats aprox. And those values are never changing. So I was wondering whether an offline DB for that would be better. I mean an array, XML or a project file via AJAX.
On the other hand, Perhaps the fact that once a player chooses a team, he is allowed to save that team for future battles, means that teams must be saved on the same DB than soldiers, in order to be accessed. So, it should be an online DB. Am I wrong?
I am no programmer, so my undestanding comes from reading the tutorials and the posts from the forum.
Maybe I can create an offline DB for the soldiers and an online DB for the players' teams, which calls the soldiers DB.
Anyway, I've been reading some people cpncerns about SQL not being as safe as JSON. The same for XML. And also people telling arrays with so many fiels slow down performance. Can someone lighten me?