27.06.2013, 14:17
Hey SA:MP community! I've got some little questions about MySQL as I'm a beginner.
So - I have a MySQL R7-based account system but I'm wondering - let's say I would have 100 players online at once on my server(dreams lol). How should I save the account information? Should I save ALL the data when the player disconnects? Should I save only one field every time the variable for that field changes? Like everytime a player's money changes I should execute a query which saves the `Money` field in the database?
How and when do you save data using MySQL on your SA:MP server?
So - I have a MySQL R7-based account system but I'm wondering - let's say I would have 100 players online at once on my server(dreams lol). How should I save the account information? Should I save ALL the data when the player disconnects? Should I save only one field every time the variable for that field changes? Like everytime a player's money changes I should execute a query which saves the `Money` field in the database?
How and when do you save data using MySQL on your SA:MP server?