MySQL query: What is faster?
#1

Well, I was scripting, and suddently something came to my mind, what would be faster:
Calling 2 query's
pawn Code:
function SaveStats(playerid)
{
    static Query[180];
    format(Query,sizeof Query,"UPDATE `Accounts` SET `Money` = '%i', `Score` = '%i', `Kills` = '%i', `Deaths` = '%i', `Arrests` = '%i', `Robs` = '%i', `Wantedlevel` = '%i' WHERE `Username` = '%s' LIMIT 1",
    GetPlayerMoney(playerid),
    GetPlayerScore(playerid),
    PInfo[playerid][Kills],
    PInfo[playerid][Deaths],
    PInfo[playerid][Arrests],
    PInfo[playerid][Robs],
    GetPlayerWantedLevel(playerid),
    GetPName(playerid));
    mysql_query(Query);
   
    format(Query,sizeof Query,"UPDATE `Accounts` SET `Jailed` = '1', `Jailtime` = '%i' WHERE `Username` = '%s' LIMIT 1",
    PInfo[playerid][Jailtime],
    GetPName(playerid));
    mysql_query(Query);
    return 1;
}
Or Making it all in 1 query but creating more cells?
IE, instead of static Query[180];, putting static Query[280];
What would be faster?
Reply


Messages In This Thread
MySQL query: What is faster? - by FireCat - 19.07.2012, 15:11
Re: MySQL query: What is faster? - by IstuntmanI - 19.07.2012, 15:20
Re: MySQL query: What is faster? - by Mauzen - 19.07.2012, 17:43
Re: MySQL query: What is faster? - by Kiets - 19.07.2012, 18:09
Re: MySQL query: What is faster? - by FireCat - 19.07.2012, 18:29
Re: MySQL query: What is faster? - by FireCat - 19.07.2012, 19:26
Re: MySQL query: What is faster? - by ReneG - 19.07.2012, 20:10
Re: MySQL query: What is faster? - by FireCat - 19.07.2012, 20:24
Re: MySQL query: What is faster? - by SuperViper - 19.07.2012, 22:08
Re: MySQL query: What is faster? - by TheArcher - 25.07.2012, 09:24

Forum Jump:


Users browsing this thread: 1 Guest(s)