[DRIFT_HUNTER]

Simple question

Is it better to use big query's and fetch

pawn Код:

new Query[200]; //Creates the Query string and the Pname
    format(Query, sizeof(Query), "SELECT * FROM `users` WHERE `User` = '%s'", ESCpName);
    mysql_query(Query);

And now fetch row (it will be very big and its very hard to script it)
Or use it like

pawn Код:

stock GetFromAccount(username[], obtaining[], holdingvar[])
{
    format(Query, sizeof(Query), "SELECT `%s` FROM `Accounts` WHERE `Username` = '%s'", obtaining, username);
    mysql_query(Query);
    mysql_store_result();

    if(mysql_fetch_row(holdingvar) == 1)
    {
        mysql_free_result();
    }
    return 1;
}

These one is easy way same like wirh DINI or DJSON but i think it will be slower than fetch row....


So what you say? what is better for server speed?