RE: Informix Data Warehouses
Posted in 1998
Topics: Server Administration
We've been using Informix 7.23 in our Data Warehouse environment for some time now and have never gotten bytten by any of the bugs Naomi had heard about.someIn article <6ne75o$f1$1@news.xmission.com>, "Sleeper, Derek" <iidqs@brightpoint.com> wrote: > > > 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 # > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum