I’m just going to jump into this one.
I could go one of two ways, the first is slightly more flexible than the other with a possible reduction in speed.
I’m here to figure out if it truly will be a reduction in speed or not.
Say each player has a variable for Money/Experience/Something that changes quite frequently and needs to eventually be saved in a database as quickly as possible.
Would one run into issues saving AND loading the value of said variable from the database every time its needed?
I have had issues in the past where the server would lock up for 3-5 seconds just saving a single variable from 10+ players at the same time to the database every 5 minutes(which was changed to every 40min to negate the short lockup, it still happened nonetheless just not as often).
As always your help is most appreciated and thanks in advance!
I’m just trying to prevent recoding a few things down the road if possible. :]