I personally prefer MS SQL as I find it more robust but mySQL is more available on servers and its free...
Anyway....some news on the Live Timing updates....looking good! So basically, I'm going hardcore on this and use one of the best streaming web socket technologies out there which can handle thousands of connections.
Apart from that, I am also making huge changes how everything works so that there is no load on the game server.
Listener on Game Server with rF2 listens to rF2 Plugin ---->Listener sends data to web Server through 1 socket ----> web server streams all the data to all connected users to live timing app
That means that Game Server will now only have 1 extra connection and not to all web users. This put only minimal load on Game server. The web server will do all the work including the database. Having said that, the IIS server, mysql database and the streaming module (the new stuff) can be on any server, including the same game server if you want. Its its gonna be kinda very flexible.
The downside: the setup will be more complex now but I will try to make it easy as possible. I'm not going to settle for a clumsy/slow/not robust live timing so unfortunately to be flexible and robust it would need more setup effort.
In fact, testing on VEC environment has stopped as we do not have full control to open ports and setup modules as we wish without waiting for some admin to help us. So I'll be looking for a server/s to test this new environment and package all the new stuff.
Cheers