SA-MP slow
#1

Fixed!
Reply
#2

Nope
Reply
#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


Forum Jump:


Users browsing this thread: 1 Guest(s)