Re: Informix and Oracle in the same shop

In article <5mv3bq$5po@cssun.mathcs.emory.edu>, ic <iac@frc.com> writes >Definitely have to agree with Pablo on this one. > > >* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > >On 2 Jun 1997, Pablo Sanchez wrote: > >} >} In article <01bc6e57$5fdd9ae0$618285ce@ian>, "Ian Sparkes" ><sparkes@sprintmail.com> writes: >} > I would also be interested in hearing why you feel Informix is a better >} > choice for a large data warehouse. >} > >} > The major differentiation between Oracle and Informix is normally the >} > available tools. Specifically, Informix has nothing like Designer/2000 and >} > having a powerful tool to manage schemas is real critical in a large >} > warehouse. >} > >} >} At the risk of sounding boring, I'd have to agree with Ian. If this >} shop is already Oracle, why incur the cost of retooling people to >} learn another RDBMS. I see Ian's point that for all intents and >} purposes an RDBMS is an RDBMS is an RDBMS. >} -- Because Oracle cannot handle the amount of data and workload that Informix can. Note the latest TPC-D benchmark 70% faster than Oracle on similar hardware... Informix is truely multi-threaded therefore can handle higher workloads with parallel queries NOT requireing context switching between several UNIX processes. Oracle is not truely multi-threaded. Instead Oracle has connection PROCESSES and a group of work PROCESSES. >} Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or- pablo_p@pager.sgi.com >} --------------+-----------------+-------------------------------------------- >} pablo@sgi.com ... when mailing me, place "not spam" in the Subject >} -- David Williams