Mailing List Archive


Back to the month index Back to the list index
Andre van der Vlies (A.G.van.der.Vlies@cb.hva.nl)
Thu, 10 Apr 1997 09:53:09 +0200 (CDT) 

Date: Thu, 10 Apr 1997 09:53:09 +0200 (CDT)
From: Andre van der Vlies <A.G.van.der.Vlies@cb.hva.nl>
Subject: Re: Fw: [mSQL] Locking?
Message-Id: <Pine.SGI.3.94.970410094705.29505A-100000@ice.cb.hva.nl>

On Wed, 9 Apr 1997, Justin Subert wrote:

> Doug Salot wrote:
>
> If the database engine had the commands ATOMIC START and ATOMIC STOP
> which could be wrapped around statements required to be treated as an
> atomic group, would we remove the need for locking? I am sure there are
> implications I have not considered, but assuming none of the statements
> were processed until the ATOMIC STOP was recieved and all the statements
> were passed I can see no drawbacks to this approach, other that the
> database being unavailable for longer contignous periods.
>

Perhaps a new clause:
        CHANGE IN table salary=40000 TO salary=60000

Only updating the fields if both conditions are true. salary is 40000 and
after updating is 60000. All in one operation.

                           Andre van der Vlies <A.G.van.der.Vlies@cb.hva.nl>
                           System Administrator
                           Hogeschool van Amsterdam
                           Stadhouderskade 55, Amsterdam
                           tel: (+31) 20 5702670
                           fax: (+31) 20 5702510
                           http://www.cb.hva.nl/~andre
Key fingerprint = 99 DC D6 01 96 C2 48 80 DC 9C D5 D2 34 F6 A6 5D

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!