RE: Informix Data Warehouses

I'd have to agree with Paul on this one. I worked at a major pharmaceutical benefit management company that used Informix 7.21 for their data warehouse. The system was an HP K420 if I remember right. The clients used SAGENT and Business Objects to do their AdHoc queries. The warehouse contained over 75 Gig of data (45 Gig in one 170,000,000 row table - I didn't set up that one). Through proper fragmentation and the use of PDQ, they were quite happy with it. Derek M. Sleeper Management Information Consulting <mailto:dsleeper@micinc.com> dsleeper@micinc.com / <mailto:iidqs@brightpoint.com> iidqs@brightpoint.com -----Original Message----- From: Paul Watson [SMTP:P.Watson@LIV001.dss.gov.uk] Sent: Wednesday, July 01, 1998 10:19 AM To: informix-list@iiug.org Subject: Re: Informix Data Warehouses Naomi Walker wrote: > We have been an Informix OLTP shop for many years, and are now in the > process of deciding on a database engine for our data warehouse (on a > Sun E10k). I have heard through the grapevine that there are > considerable problems with Informix that cause data to be lost, and > problems with its general administration (like lots of broken indicies). > > Is anyone out there running a data warehouse using Informix care to offer > me some feedback? > > Thanks! > > -- > Naomi Walker (aka N7FSA) | naomi@anasazi.com > | Phoenix, Arizona > ---------------------------------------------------------------------- > It's almost impossible to overestimate the unimportance of most things. Yes - the people on the grapevine are talking total and uttter bollocks -- Paul Watson # WF Software Ltd # I don't suffer from stress - Tel: +44 1436 674729 # I'm a carrier. Fax: +44 1436 678693 # www.wfsoftware.co.uk #