(C# server)
It might be easier if I go over my use case, I'm trying to create a simple text based game with anywhere from 100-10,000 players per server. The game is very simple, the clients will update their own userData at set intervals (players have 50seconds to input, then the server has 10seconds to process), this is repeated for as many rounds as there are in a specific gamemode (predefined, 3-7).
At the end of each user input phase the server will query through all connected players to get their userData to cache for later use in the game.
I wanted to know if there was a way to batch all of the queries (will paginate in the 1000s of users) so that I can send off fewer overall queries and just have multiple players data returned per operation.