[Glite]

This doesn't help. Insertion query doesn't require alot of time. The ones which do are: GetTotalRank and GetCurrentRank.

[shavit]

Originally Posted by Glite This doesn't help. Insertion query doesn't require alot of time. The ones which do are: GetTotalRank and GetCurrentRank.

My round table has almost 9,000 rows and it really helps me.
Threaded queries are better in this case.

About those, both can be threaded.

GetTotalRank(const String:map[])
{
    decl String:sQuery[448];
    FormatEx(sQuery, sizeof(sQuery), "SELECT m.id, m.auth, m.time, MAX(m.jumps) jumps, m.physicsdifficulty, m.name FROM round AS m INNER JOIN (SELECT MIN(n.time) time, n.auth FROM round n WHERE n.map = '%s' GROUP BY n.physicsdifficulty, n.auth) AS j ON (j.time = m.time AND j.auth = m.auth) WHERE m.map = '%s' GROUP BY m.physicsdifficulty, m.auth", map, map);
    
    SQL_TQuery(g_hSQL, GetTotalRankCallback, sQuery, 0);
}

public GetTotalRankCallback(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("SQL Error on GetTotalRank: %s", error);
        
        return;
    }
    
    g_iTotalRankCache = SQL_FetchRow(hndl)? SQL_GetRowCount(hndl):0;
    
    CloseHandle(hndl);
}

GetCurrentRank(client, const String:map[])
{
    decl String:sQuery[512];
    FormatEx(sQuery, sizeof(sQuery), "SELECT m.id, m.auth, m.time, MAX(m.jumps) jumps, m.physicsdifficulty, m.name FROM round AS m INNER JOIN (SELECT MIN(n.time) time, n.auth FROM round n WHERE n.map = '%s' AND n.time <= %f GROUP BY n.physicsdifficulty, n.auth) AS j ON (j.time = m.time AND j.auth = m.auth) WHERE m.map = '%s' AND m.time <= %f GROUP BY m.physicsdifficulty, m.auth", map, g_bestTimeCache[client][Time] + 0.0001, map, g_bestTimeCache[client][Time] + 0.0001);

    SQL_TQuery(g_hSQL, GetCurrentRankCallback, sQuery, 0);
}

public GetCurrentRankCallback(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("SQL Error on GetCurrentRank: %s", error);
        
        return;
    }
    
    g_iCurrentRankCache[client] = SQL_GetRowCount(hndl);
    
    CloseHandle(hndl);
}

[Glite]

You can't. You broke everything with this. FinishRound function requires immediate result from those queries.

[zipcore]

Originally Posted by Glite You can't. You broke everything with this. FinishRound function requires immediate result from those queries.

Use yu recrd buffer.

[Glite]

Originally Posted by zipcore Use yu recrd buffer.

I have in mind this idea, but i don't have time to do this...

[shavit]

Originally Posted by Glite You can't. You broke everything with this. FinishRound function requires immediate result from those queries.

Then wait for both results from queries and after that do everything else in FinishRound.

[nikedu45]

Originally Posted by shavit timer-core.sp

error 017: undefined symbol "SQL_LockDatabse"
error 017: undefined symbol "SQL_UnlockDatabse"

[Glite]

Originally Posted by nikedu45 error 017: undefined symbol "SQL_LockDatabse" error 017: undefined symbol "SQL_UnlockDatabse"

Don't use it. It brokes correct position definition after finishing the map.

[takaharrue]

THe timer-hud is not showing up for me, and in my admin menu, I have no timer commands. I'm pretty sure I configured everything correctly.

[nikedu45]

You really need to make a correction, the plugin is broken it causes huge lag on the server