Hi guys, I’ve recently had a great game idea and I need a way to store data on a server to create a “multiplayer” illusion. I was looking into an mysql server and I have one up and running and stuff, that being said I want to know how fast I can read and write data to an mysql server. For example, say I was using a table to send chat messages to another client accessing the same server, would the delay be really really long or decently short, and also just to mention it, I know some basic php, and I am sure I can write all the php required, I also however will need a separate program/service that updates the current server time value and other stuff like that in the mysql database in the background, sort of like a network manager, update time, move data around occasionally when it needs to be, things clients can’t be trusted to do (and maybe I can run the program on the vps that my mysql server is on so it wouldn’t have any latency?).
Please let me know what you think about this idea, and please suggest a better way of doing it if you know something I don’t (which I am sure you do).
I am hoping that I don’t have to use a dedicated server to handle text data, the game will not be all text based but some of it will and I don’t think that clients connecting to a dedicated server is very efficient.
Anyways can’t wait for your feedback! Hopefully this plugin will solve some of my problems.