MySQL Question - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Question (/showthread.php?tid=373163)

---

MySQL Question - CONTROLA - 29.08.2012

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!

---