Re: OpenIngres vs Oracle

I have been administering and developing with Ingres V6.4, OI V1.2/2.0, MS SQL Server V6.x and Oracle V7.1/7.2/7.3/8.0 for about 7 years now.

I would TOTALLY recommend Oracle over Ingres. No question in my mind that Oracle is more robust, much easier to integrate with middleware software and has tons of vars, oems and 3rd party support. And if you are running home grown applications against the RDBMS, you'll have much better connectivity and more options.

Plus, Oracle runs way, way, way faster than Ingres or OpenIngres. Obviously there are many more factors to the equation. I've put those factors into my equations and the results favor Oracle unanimously over Ingres.

BTW, if you are interested, as you mentioned the possibility of replacing h/w too. I configured a Oracle RDBMS server using a Intel based H/P NetServer running WNT at a cost of approx. $60K that outperforms a similarly configured H/P 9000 K100 running H/P UX B.10.01 at a cost > $100K. And did it with double digit percentage performance improvement.

I surprised alot of people and most importantly myself.

Have fun!

Greg Pavlov wrote in message <622qi1$ojr_at_niktow.canisius.edu>...
>
> We are at a crossroads: do we migrate to OpenIngres or Oracle ?
> I would be interested in hearing from anyone who addressed this
> decision formally, how you reached your conclusion, and what has
> been the aftermath. We have used Ingres since version 3 and are
> currently at 6.4. We are a moderate-sized installation running
> on a mix of DEC MIPS and IBM RS6000 machines, most to be replaced
> soon. Our largest database contains apx. 1500 tables consuming
> apx. 5 GB of disk and we have apx. 150 "intense" and 250 "casual"
> users. To be honest, our ambivalence is much more with CA than
> Ingres itself.
>
>
>
> greg pavlov
> [not affiliated with Canisius College]
>
> *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> Bipolar, adj.:
> Refers to someone who has homes in
> Nome, Alaska, and Buffalo, New York
> *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
>
Received on Sat Oct 18 1997 - 00:00:00 CDT