18.01.2015, 12:23
Thank you for your replies!
Well, let's start...
1. My String/Query sizes are at average, I mean, MAYBE I could decrease some cell sizes.
2. Do you mean Parent and Child thing? Well I just started creating my script and I only have player accounts table and business table. Business table is large, but it's loading only when I start the server. Maybe I could do the Parent and Child thing with businesses, what do you think?
3. I am using like this...
Tell me , please, more about the other option, I am not familiar with it.
4. No. I will try to load all major/huge stuff on the very beggining , like OnGameModeInit.
Also, I am updating only when is needed, not on disconnect.
Well, let's start...
1. My String/Query sizes are at average, I mean, MAYBE I could decrease some cell sizes.
2. Do you mean Parent and Child thing? Well I just started creating my script and I only have player accounts table and business table. Business table is large, but it's loading only when I start the server. Maybe I could do the Parent and Child thing with businesses, what do you think?
3. I am using like this...
pawn Code:
mysql_format(MySQLHandle, query, sizeof(query),"SELECT PlayerPass, IDPlayer FROM users WHERE PlayerName = '%e' LIMIT 1", GetName(playerid));
mysql_tquery(MySQLHandle, query, "OnAccountCheck", "ii", playerid, MySQLCheck[playerid]);
4. No. I will try to load all major/huge stuff on the very beggining , like OnGameModeInit.
Also, I am updating only when is needed, not on disconnect.