29.08.2012, 14:43
Hey guys. Recently I started using MySQL for storing my players' data but I've got a problem:
I'm using a roleplay gamemode so at fixed hours all the players are getting a payday. The problem is that I'm saving ~3 values for every player, so if I'm passing 80 players the server would freeze for about a minute. Do you have any idea how I can get rid of this problem? I think there are too much queries that are done all at once.. And I think OnQueryFinish callback could be of help, but I'm a begginer in MySQL so I don't have any idea about how to do this. Can you help me?
Thank you!
I'm using a roleplay gamemode so at fixed hours all the players are getting a payday. The problem is that I'm saving ~3 values for every player, so if I'm passing 80 players the server would freeze for about a minute. Do you have any idea how I can get rid of this problem? I think there are too much queries that are done all at once.. And I think OnQueryFinish callback could be of help, but I'm a begginer in MySQL so I don't have any idea about how to do this. Can you help me?
Thank you!