Quote:
Originally Posted by BurnZ
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.