Re: ExclusiveLock
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52928
interpreted = N
texte = My understanding is that WebDNA does an implied exclusive lock around each append, replace or delete. The only times I generally use [exclusivelock] are when I'm doing some more complex operation, usually involving multiple databases, and I want to ensure that all necessary databases are available and nobody messes with them while I'm updating. For example: [exclusivelock order.db,oitems.db,member.db] .... code that updates the order, the items and the member, as when they submit an order ... [/exclusivelock] SMSI: Care to comment? - brian On Tuesday, September 16, 2003, at 12:11 PM, Donovan wrote: > WebDna @ wrote: >> Yes well, the fact that you used it lead to the question. :) >> I wanted to know if it is needed. I am one of those who like to have >> as >> little code as possible. > > Ah, :-) I would be interested also. I started using it after seeing > in > Johns DBEdit code (after some commit issues). > > There is probably a greater sience of knowing when to use the different > flush commit close databases and knowing when to use Exclusivelock. > > This also is impacted by your preference settings. If you choose > "Automatically commit databases to disk after modification", you > probably can take out the commitdatabase after your [append] etc. > I have this pref turned on AND I use the manual [commit]. I suppose > that I would consider taking the contexts out if the pages were slow. > > One good thing about using them though is that the code is more > portable... (the next server the code lies on might not have this > pref enabled). > > I would assume Exclusivelock is more for databases that get edited > from multiple locations at near the same time. > > Donovan > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
My understanding is that WebDNA does an implied exclusive lock around each append, replace or delete. The only times I generally use [exclusivelock] are when I'm doing some more complex operation, usually involving multiple databases, and I want to ensure that all necessary databases are available and nobody messes with them while I'm updating. For example: [exclusivelock order.db,oitems.db,member.db] .... code that updates the order, the items and the member, as when they submit an order ... [/exclusivelock] SMSI: Care to comment? - brian On Tuesday, September 16, 2003, at 12:11 PM, Donovan wrote: > WebDna @ wrote: >> Yes well, the fact that you used it lead to the question. :) >> I wanted to know if it is needed. I am one of those who like to have >> as >> little code as possible. > > Ah, :-) I would be interested also. I started using it after seeing > in > Johns DBEdit code (after some commit issues). > > There is probably a greater sience of knowing when to use the different > flush commit close databases and knowing when to use Exclusivelock. > > This also is impacted by your preference settings. If you choose > "Automatically commit databases to disk after modification", you > probably can take out the commitdatabase after your [append] etc. > I have this pref turned on AND I use the manual [commit]. I suppose > that I would consider taking the contexts out if the pages were slow. > > One good thing about using them though is that the code is more > portable... (the next server the code lies on might not have this > pref enabled). > > I would assume Exclusivelock is more for databases that get edited > from multiple locations at near the same time. > > Donovan > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Brian Fries
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Random (2000)
WebCat Admin access w/ClearlyHome p.i. (1997)
Snake Bites (1997)
[format xs] freeze (1997)
WebCatalog memory error. (1998)
How do you hide [math]stuff[/math] (1997)
Not really WebCat (1997)
Editing Users.db (1997)
WebMerchant 2.1.2 (1998)
Database changes (1998)
New Command prefs ... (1997)
[WebDNA] incomplete redirect tag (2009)
Emailer Error Question (1998)
[WebDNA] Searching for encrypted values (2014)
PHP Live (2005)
Webmessage Hyperboard (1998)
Processing all html files through WebCat or Typhoon (1998)
Frames (1997)
POSTing to a secure server ... (2000)
Roundup function? (1997)