27.03.2011, 11:53
Hello friends, i have a fuc* problem with my SQL Query, it takes 33sec to Upgrade the Admin column for 1 Player.
If i update the Admin Column for 500 players the server goes busy for nearly 20 sec, so the process takes up to 20sec...
if i remember right, sql saved once 500 players with lots of stuff in nearly 1sec.
idk what im doing wrong... i need some help...
PS: Im using StrickenKids SQL Plugin.
If i update the Admin Column for 500 players the server goes busy for nearly 20 sec, so the process takes up to 20sec...
if i remember right, sql saved once 500 players with lots of stuff in nearly 1sec.
idk what im doing wrong... i need some help...
PS: Im using StrickenKids SQL Plugin.
Code:
#define Query( format(sql, sizeof(sql), new sql[512]; new s = GetTickCount(); Query("UPDATE Accounts SET Admin='5' WHERE Username='Cox'"); mysql_query(sql); printf("Time used: %i", GetTickCount() - s);