[omario]

Hello,
My server has been lagging since yesterday, when i re-scripted my mysql account system
i found that the server stops working, when i update any field, for about 10sec

that's the updating stock which i use:

pawn Код:

stock MySQL_UpdateInt(const AccountName[], const FieldName[], IntValue)
{
    new query[512];
    format(query, sizeof(query), "UPDATE `accounts` SET `%s` = '%d' WHERE `Username` = '%s'", FieldName, intValue, Account);
    mysql_query(query);
    return 1;
}

Please tell me a way to solve this problem
sorry for bad english