Server lag
#7

I checked again some scripts from that timer and I saw that i'm using a lot of queries in that timer, like:
Код HTML:
new str[256];
						format(str,128,"UPDATE `players` SET `Warns`='0' WHERE `playerID`='%d'",PlayerData[x][pSQLID]);
						mysql_tquery(handle,str);
It is a big problem because there are executed a lot of queries for all the connected players every second, isn't it?

But it is executed just in case. Like :
Код HTML:
if(PlayerData[playerid][pWarns] > 3)
{
 ban
 query
}
so, i guess that isn't the real problem from that lag.
Reply


Messages In This Thread
Server lag - by Nin9r - 18.02.2017, 21:50
Re: Server lag - by GoldenLion - 18.02.2017, 22:25
Re: Server lag - by Nin9r - 18.02.2017, 22:31
Re: Server lag - by GoldenLion - 18.02.2017, 22:34
Re: Server lag - by Nin9r - 18.02.2017, 22:40
Re: Server lag - by GoldenLion - 18.02.2017, 22:41
Re: Server lag - by Nin9r - 18.02.2017, 23:19
Re: Server lag - by Sew_Sumi - 18.02.2017, 23:53
Re: Server lag - by Nin9r - 19.02.2017, 12:25
Re: Server lag - by Vince - 19.02.2017, 12:36

Forum Jump:


Users browsing this thread: 1 Guest(s)