Is it efficient to save game data and load all variables including lists from JSON into to a MYSQL database?

Question

I am intend to savegame save and load all the player data in json to mysql database using database unity with PHP. Is it effective ?.

My analysis that we don't need to use binary formatter to make a savegame file and if saving and convert the savegame data to mysql database our game can login and load continues play in any devices. We also have a big capacity i think in the disk.

If we save to database mysql we also don't need to used a transfer device feature to move to another devices if want to continues playing with the different mobile devices. All we need just login to database to get the savegame that store i Database Mysql.

Is this sense a problem with this way ? Like maybe making it lag or slowdown the game and soon.

Many Thanks

score 0 · Accepted Answer · edited May 23 '17 at 12:08

0

Well the strong reply to your question is it depends on different things. Two consideration according to my understanding with respect to your question,

If you want to maintain user score-board or access of user game data across different devices then you have to store data on server. No matter what are the loading/unloading time concerns

else

You can store it in user mobile like use writing text file or PlayerPrefs

You can also read Best Way to store data in Unity3d

edited May 23 '17 at 12:08

Community

1
1

answered Aug 12 '16 at 11:16

Muhammad Faizan Khan

10,013
18
97
186

Hey @Mohammad, but i am not intend to use binary formater that writing text file because I think its got trouble when we use different devices to play and I think using PlayerPrefs also not effective in saving game because it take big data. – Dennis Liu Aug 12 '16 at 11:29
Hey @Mohammad, where i can find the tutorial save game using google play services savegame ? Thanks – Dennis Liu Aug 12 '16 at 11:50
Google Play services have a save game services. See this link : [link](https://developers.google.com/games/services/android/savedgames) But i dont get how it work – Dennis Liu Aug 12 '16 at 12:12
oh so i guess you to spend some money https://www.assetstore.unity3d.com/en/#!/content/8808 – Muhammad Faizan Khan Aug 12 '16 at 12:22
or you can use open source free https://github.com/playgameservices/play-games-plugin-for-unity – Muhammad Faizan Khan Aug 12 '16 at 12:23
Which is better ? the one from assesstore or the one from github ? – Dennis Liu Aug 12 '16 at 14:17
@DennisLiu no idea you first try free github version – Muhammad Faizan Khan Aug 15 '16 at 04:41

Is it efficient to save game data and load all variables including lists from JSON into to a MYSQL database?

1 Answers1