as a second year project in SE me and few friends took a projoct of 3d game .
on the server side:
what is the preffered way to work with user info we took the next scheme but i guess that there is a better way .
on the server there is :
game server application.
in the server there is 1 mb array for users and ids.
the game_server recives a connection and create new thread that checks the request:
if this is read_request it takes if it is postion request it takes from the array and return data.
if this a write_request for postion it it update the array and start a new thread that will update the sql server.
if this a read_request for function it just open new thread for the sql_request .
if this a write_request for function it lock and update the spesific line in the data base.
my question are :
is it a proper approach to create a cache for the often called functions or it is better just to use the sql server.
also what do you about our approach for the data processing (using threads and not making one long que).