SQLite query takes long time to perform
#7

Here it is:

PHP код:
stock SavePlayerData(playerid)
{
    if(
pLogged[playerid] == false) return 0;
    new 
tick tickcount();
 
    
format(Query,sizeof(Query),"UPDATE `USERS` SET ALEVEL = %i, KILLS = %i, DEATHS = %i, HSPREE = %i, TIMEP = '%s', MAINSET = '%s', PTOKEN = %i, PMONEY = %i, PlayerLevel = %i, PlayerLevelExp = %i, TotalExp = %i WHERE `UserID` = %i",
    
PlayerInfo[playerid][aLevel], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths], PlayerInfo[playerid][hSpree], DB_Escape(timeString), DB_Escape(cfgString), PlayerInfo[playerid][pTokens], PlayerInfo[playerid][pMoney], PlayerExp[playerid][0], PlayerExp[playerid][1], PlayerExp[playerid][2], PlayerInfo[playerid][UserID]);
    
db_query(DatabaseQuery);
    
    
printf("SavePlayerData took: %i ms"tickcount() - tick);
    return 
1;

Reply


Messages In This Thread
SQLite query takes long time to perform - by jbankss - 09.01.2017, 22:08
Re: SQLite takes long time to perform queries - by MarkNelson - 09.01.2017, 22:19
Re: SQLite takes long time to perform queries - by jbankss - 09.01.2017, 22:22
Re: SQLite query takes long time to perform - by Jefff - 09.01.2017, 22:36
Re: SQLite query takes long time to perform - by jbankss - 09.01.2017, 23:21
Re: SQLite query takes long time to perform - by Jefff - 10.01.2017, 00:05
Re: SQLite query takes long time to perform - by jbankss - 10.01.2017, 00:08
Re: SQLite query takes long time to perform - by Jefff - 10.01.2017, 01:05
Re: SQLite query takes long time to perform - by Lordzy - 10.01.2017, 01:36
Re: SQLite query takes long time to perform - by jbankss - 10.01.2017, 02:14

Forum Jump:


Users browsing this thread: 1 Guest(s)