[Info-ingres] Was row-level locking ever an "extra cost" option?

[Roy Hann]

Chris Clark wrote:

> On Friday, July 5, 2019 at 10:04:04 AM UTC-7, Karl and Betty Schendel wrote:
>> > On Jul 5, 2019, at 6:43 AM, Roy Hann <specially at processed.almost.meat> wrote:
>> > 
>> > My memory fades. Was row-level locking ever an "extra cost" option?
>> > 
>> > I don't think it was but funny things happened in the past, like
>> > creating tables (briefly) being an extra cost option...!
>> 
>> 
>> I'm not 100% certain, but I don't believe it was ever license-controlled.
>
> I can confirm Marty is correct, it was added as a new feature to the base 
> product. You did need to use larger (than 2Kb) page sizes to make use 
> of it so some minor DBA work was needed if upgrading. 

Thank you Chris, Karl, Marty.

Row-level locking was released in (I think) Ingres II 2.0, circa 
circa 1997, which was also the release that supported so-called large
pages.

The reason I was asking about this was curiosity about why the system I
am looking at just now has loads of homebrewed optimistic locking code.

Your combined answers make me wonder if they were just unwilling to
pioneer the use of two new features (in 1997). Code-your-own
optimistic locking may have seemed like a safer idea at the time. (I am
not sure they were right then, and I am certain it's a problem now.)

I think they could have done other things to avoid the contention they
were expecting (if not experiencing), but here we are.

Roy