I had a hoster who wanted to ran a creative server. OK no prob, hook him up to my MySQL database and boom done. But (I assume) the added latency of sending all the info to my machine, then back was too much (on his internet atleast).
So instead I created a local MySQL server on his computer, and the problem at hand was severely lowered, but there was still a notable amount of lag everytime someone /save’d their kit.
Furthermore, I recently found a server network that runs Creative servers, and they suffer from EXTREME lag everytime someone saves their kit, and I essentially crashed the server by spamming /save. I tried to tell the Owner that he needs to put the MySQL locally on the same machine, to which he said it already was.
I’m not familiar with coding or how Unturned works. What is the cause of all this lag, just guessing without actually looking at the code for reference. Is the server stalling because its waiting for the operation of the plugin (saving someones inventory and kit) to the database? That would be dumb though, and lead to this. I speculate that (hopefully) plugin creators aren’t that dumb.
But then what would it be? If its not computation power, or latency between server and database, nor read/write speeds, then what could possibly be the source of such horrible lag, if not the plugins own terrible code and/or Unturned’s terrible behavior?