"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1090027361.387590_at_yasure...
>
>
> michael newport wrote:
>
> > Jon,
> >
> > check out www.ca.com for Ingres, its the same strength as Oracle but
> > will shortly be OpenSource.
> >
> > Regards
> > Michael Newport
>
> And by 'strength' you mean?
>
> Daniel Morgan
>
I think he means it is good at locking. It has a strong locking mechanism.
Last time I used Ingress (quite a few years ago) an insert into a table
would lock the whole table! Why? It had page level locks and inserting a
record into a table with a primary key locks the entire index which means
only 1 person at a time could insert records. You had to commit to release
the locks. So don't have long running transactions. Leads to bad
programming practices; developers putting the system into autocommit mode.
(yeach)
Jim
Received on Fri Jul 16 2004 - 21:15:36 CDT
