SA-MP slow
#3

Quote:
Originally Posted by BurnZ
View Post
Nope
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.
Reply


Messages In This Thread
SA-MP slow - by Sc0pion - 17.06.2016, 05:14
Re: SA-MP slow - by BurnZ - 17.06.2016, 05:42
Re: SA-MP slow - by Sjn - 17.06.2016, 08:15

Forum Jump:


Users browsing this thread: 2 Guest(s)