The current routine to load the player data first attempts an Insert at normal priority and then a select at low priority. I believe this to be backwards, selects can happen concurrently in
the database but inserts and updates lock the table so only one my occur at a time. This is especially a problem, when 80% or so of the people in a server were there the last round and thus have entries in the database already. Evidence of this problem is the full minute that is required to load player data at the beginning of a round.
I believe select should be attempted first and then, if no records are returned, should an insert be tried.
Please find attached my rewrite of that section, if you find any errors please let me know. I am new to source pawn.
Jon
PS, I tried to sign up to the bug ticketing system, never got an email.




Logged



DarkEnergy