30.01.2016, 13:00
What the title says, is it acceptable to send a SELECT statement to a MySQL database OnPlayerUpdate?
The purpose of me sending a SELECT statement every player update is to determine in what zone they currently are. Zone coordinates are saved in a MySQL table, so it runs through it to check that.
If this is not recommended at all (which I could imagine because OnPlayerUpdate is sensitive), what would the most performance friendly solution be?
The purpose of me sending a SELECT statement every player update is to determine in what zone they currently are. Zone coordinates are saved in a MySQL table, so it runs through it to check that.
If this is not recommended at all (which I could imagine because OnPlayerUpdate is sensitive), what would the most performance friendly solution be?