SA-MP slow - 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: SA-MP slow (/showthread.php?tid=609839)

---

SA-MP slow - Sc0pion - 17.06.2016

Fixed!

---

Re: SA-MP slow - BurnZ - 17.06.2016

Nope

---

Re: SA-MP slow - Sjn - 17.06.2016

It pretty much does. Imagine, a saving function getting called which probably has a large cell of query inside it for 10 players at once every 2 minutes.

Instead of sending a huge query to update the user's table every minute or two, why not just send a small query to update the data whenever it makes changes? Let's say you need to update the admin level only, and you call the saving function, it would send a large query (probably having a query cell of 300 and more) and update other unnecessary data as well, which has no value changed in it. While sending a small query of 56 cell to update only the admin level would be a lot better from my experience. This method can also have a bad side but from my view, it's a lot better than sending a huge query to update everything at once. Like most of the people does.

Side note: Disable mysql logging if you don't need it. It will slower down the query execution time.

---