I've just created my first 2d game (c# XNA) - a car racing game. My problem is how to perform a multiplayer mode. I wanted to use MySQL server. I decided to try with a local database (SQLite) first. As i suspected it didn't work. The thing is that my game displays about 20 frames per second. It gives at least 40 queries to database each second. (in case of collision it may be even more). The game takes the data from database before calling the update function, than executes player's actions and finally updates database. The problem probably is the time a database needs to process queries.
The data which is sent is just a few variables ( x and y coordinates, rotation and 6 other integers related to damage)
Simple streams would probably be fast enough but they don't work without external IP.
Do you have any ideas how to fix the problem?