Re: Diferences in Engines

Posted in 1997

Paul Brown — 20 Oct 1997 22:00:24 GMT — source: Informix-list mailing list archive (1991-1998)

Herb Blacker (herbb@jcdcrs4.jobcorps.org) wrote: : We're evaluating both Universal Server and XPS. Somewhere I've heard that : one of them has several restrictions as compared to ODS 7.2x. Can anyone : out there remember what you *can't* do in these as opposed to ODS 7.2x? XPS - massively parallel on shared nothing machinery (SP2 stuff) - exceptional TPC-D / Data Warehousing performance. - No Triggers, Database Procedures. - DSS plumbing (bit mapped indices etc) - No extensibility or 'object' features. 9.X (IUS) - parallel architecture for shared memory machinery. - same underpinnings as OnLine (Good TPC-C numbers). - the full 7.X set of Database Procedure, Trigger features. - extensible plumbing (logging on blobs, spatial access methods) - 'extensible' ( new types, SQL language expressions, DataBlades). XPS (8.X) - Big SQL-92 databases, read query intensive. Universal Server (9.x) - Non-SQL-92 (or enhanced SQL-92) OLTP intensive.