BlueG 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: BlueG MySQL Question (/showthread.php?tid=614594)

---

BlueG MySQL Question - PRoleplay - 10.08.2016

Does the BLUEG SQL Plugin synchronous?

---

Re: BlueG MySQL Question - [cS]Owain - 10.08.2016

mysql_tquery and mysql_function_query are asynchronous while mysql_query is synchronous.
Use async. ones to avoid server lag.

---

Re: BlueG MySQL Question - PRoleplay - 10.08.2016

is it safe to use async? Im worrying about when the middle of saving then the playir relog or /q the game

---

Re: BlueG MySQL Question - [cS]Owain - 10.08.2016

Well while saving you just take player-data and run a update query. So even if player quits when the query is running I don't think so it would be a problem as his data is already sent to mysql server via query and change in local pawn variables when he disconnects won't affect the query as its already been sent!

All big server uses async. queries for almost all its operations these days.

---

Re: BlueG MySQL Question - PRoleplay - 10.08.2016

thanks man EDIT: Do need to restart mysql regularly? to avoid lag? or not?

---

Re: BlueG MySQL Question - [cS]Owain - 10.08.2016

No.
My server runs for weeks sometimes one month+ without reloading plugins.

---

Re: BlueG MySQL Question - PRoleplay - 10.08.2016

imean if or everytme do Restart on my gamemode do i need to restart mysql too?

---

Re: BlueG MySQL Question - BroZeus - 10.08.2016

Nope.

---

Re: BlueG MySQL Question - BroZeus - 10.08.2016

Edit: wrong post sorry.

---