Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

On Tue, 02 Dec 1997 17:51:48 +1000, Anthony Mandic <no_sp.am@agd.nsw.gov.au> wrote: :Gary L. Burnore wrote: : :> Since it's been _YEARS_ since I messed at all with Sabre, things may have :> changed. However, last I remember, the record is locked as long as an :> attendant has it on the viewscreen with the "context" set to the seat level. :> (There's a flight level, a class level and a seat level) : : The seat level context - is that all seats? : How do these translate to actual locks in a server? : I don't think its as straight forward as table, page and row. All seats within a class are displayed. As long as you have ONE of the seats highlighted, it's yours (well, it's the customer's but you have dibs on it) until you either accept it or pick a different row. For example, if two agents standing side by side are waiting on a couple and each has a seat next to the other, and they want them swapped. The agent would rather they just switch seats because both seats would have to be released at the same time to make the switch work and in that short period of time, another attendant say, at the ticket counter instead of the gate could grab the seat. I'd pretty much call that row level. : :> If you don't "do something" within a specific period, (1 minute I think) the :> context pops back to the level above (class level) and the seat is released. : : Apart from the inherit overhead, how much of a problem is : blocking at the seat level if its all seats? If you block all seats within a class, all seats are taken until you confirm the one. That's not the case. :> I'm beginning to wonder why I'm still responding to this. : : I'd have to concur. This thread's outlived its usefulness : (if it ever had any). Definately. gburnore@netcom dot com or gburnore@netcom databasix com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore | '۳'''''''ۺ''''''''''۳ | '۳'''''''ۺ''''''''''۳ DOH! | '۳'''''''ۺ''''''''''۳ | '۳ 3 4 1 4 2 '' 6 9 0 6 9 '۳ spamgard(tm): zamboni | Official Proof of Purchase =========================================================================== PGPprint: C63B CF4E 1B71 4D7E C6F8 AF4E 338D 5CB4 KeyID: 0x0F7EDBD9 (RSA) finger gburnore@netcom.com for public key ---------------------------------------------------------------------------