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

Is't Informix 8 supposed to work well in IBM/SP2-like environment (but again, OLTP support in 8 is sill not out, right?) -- Dragi Raos 4-MATE Information Engineering (http://www.4mate.hr) Zagreb, Croatia Reid Fleming <RFleming@aol.com> wrote in article <33538a45.29051694@news.jax.mindspring.com>... > Dave Raddatz <raddatz@austin.ibm.com> wrote: > > >Steve Phelan wrote: > > > >I think Larry's referring to the SP machines (mutltiple RS/6000 > >node environment) vs. what you describe as SMP machines (multiple > >chips in a single box). > > > >I believe several DB vendors have written "parallel" versions > >of their products to take advantage of the SP type machines. > > > > If they have, I would be interested in seeing how they turned out. We > had one of the first SP2's that we tried using with Sybase System 10. > Performance was poor; Sybase recommended that we wait until their > 'Navigation Server' became available. We waited for a while, but the > product, which they were co-developing with NCR (I believe) was > dropped. > > I'm not an internals expert, but several DB vendors in the past have > spoken of how much more difficult it is to 'parallelize' between > machines, versus between processors (like Informix, and to a lesser > extent, Oracle, are able to do). I like the idea of separate boxes, > and hope that they can make (or have made) this work. > >