Archived copy of war3source.com, the War3Source forum (2009–2020), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2012-10-24 (original capture). Forum · All archived topics · Wiki · Bug tracker · Blog
Chat

War3:Source
October 24, 2012, 10:06:14 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Download: http://war3source.com/index.php?board=9.0
What is War3Source?: http://war3source.com/index.php?topic=200.0
Sample Stats: http://war3source.com/war3stats
Steam Community Group: http://steamcommunity.com/groups/war3source
War3Source SVN Checkout: http://ownageclan.com/svn/war3source/
War3Source servers: http://www.game-monitor.com/search.php?vars=war3_version=
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Select should be tried before Insert  (Read 354 times)
binaryblade
Newbie
*
Posts: 3


View Profile
« on: May 27, 2010, 01:03:01 AM »

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
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2045



View Profile WWW Email
« Reply #1 on: May 27, 2010, 04:04:37 PM »

i edited out some errors, will release this in 1.0.7b
Logged

DarkEnergy
ZombieGun
Newbie
*
Posts: 31


View Profile Email
« Reply #2 on: June 10, 2010, 01:38:20 PM »

Any more suggestions that will slow down the development of War3source binaryblade?

I still am trying to recover population peaks from the "suggestion" you made and all the crashes its caused.

Logged
binaryblade
Newbie
*
Posts: 3


View Profile
« Reply #3 on: June 10, 2010, 02:23:00 PM »

Thats ok shaw, I promise not to confuse your ignorance for stupidity.
Logged
ZombieGun
Newbie
*
Posts: 31


View Profile Email
« Reply #4 on: June 10, 2010, 02:51:27 PM »

Thats ok shaw, I promise not to confuse your ignorance for stupidity.
Oh? I see, I am the ignorant one…

You know nothing of coding with PAWN and you came in here with a half-assed idea that created more problems than it solved (it did not solve any problems). Just because you read the Sourcepawn Wiki does not give you merit on making suggestions or in your case, guesses on what will work.

You have done nothing but slow the progress down of War3source. In fact, if you stop and did nothing, you would be more beneficial to everyone.

In fact, I told you this from the beginning.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!