Hello guys
I wrote this code , and i'll have 2-4 output record but when i call it server make a lag for 1 sec to all the plugins connect on mehthod remote database and other plugins like rankme dont have performance problem.
I think my codes are not optimal pls help
Code:
public Action:CommandNameFamily(client, args)
{
new String:query[255];
new String:name[32];
new String:family[32];
Format(query, sizeof(query), "select name,family from users");
new Handle:queryH = SQL_Query(db, query);
while (SQL_FetchRow(queryH)) {
SQL_FetchString(queryH, 0, name, sizeof(name))
SQL_FetchString(queryH, 1, family, sizeof(family))
PrintToChat(client, "\x01 \x04[Test]\x01 %s %s", name, family);
}
CloseHandle(queryH);
}