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

On Mon, 01 Dec 1997 23:07:05 -0600, Michael Segel <Mikey@NOSPAM.King.of.MyDomain.NOSPAM.Segel.com> wrote: : : :Anthony Mandic wrote: : :> > Tell the airlines that row-level locking isn't important. If the entire :> > seating table for a flight was locked for one attendent to assign you a seat, :> > it'd be caos. :> :> Thats a table lock. Any programmer who does this deserves what'll :> happen to him/her. :> : :Uhm.... Locking a whole table because of a single flight?No, its most likely a page lock will :lock an entire flight or class of seat assignments. :BTW, thats Chaos. ;-) Yeah, I know. One keyboard the f key doesn't always work, this one it's the h. I need the f*king f key so the h key... well anyway... : :> > Row level locking is quite important in some instances. I also agree with his :> > statement that to defend Sybase by saying that YOU don't think row level :> > locking is important is silly. :> :> I thick the claims being made are specious without any hard :> evidence to back them up. I have yet to see any. Can you or :> anyone else provide a concrete example? :> :> -am : :Gee I mention hotel reservation systems. Yet you seem to let it slide in to the vapor. :Airline reservations, etc ... :The point is that there *ARE* applications which bennifit by having row level :locking. : :As Pablo pointed out, yes, there is overhead involved. Yet, that is always the case. :Costs vs. Bennifits. Benefits :) : Row level locking has some bennifits which out weigh the costs. :Now, as I said earlier, arguing that product B is better because it lacks an option that :product A has, is silly. Its like saying that your car is a better car because it has disc :breaks, over a car which has anti lock disc breaks. OK? Now do you see my point. : : 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 ---------------------------------------------------------------------------