Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Informix and Oracle in the same shop

Re: Informix and Oracle in the same shop

From: David Williams <djw_at_smooth1.demon.co.uk>
Date: 1997/06/02
Message-ID: <7I97+CA6FykzEwSb@smooth1.demon.co.uk>#1/1

In article <5mv3bq$5po_at_cssun.mathcs.emory.edu>, ic <iac_at_frc.com> writes
>Definitely have to agree with Pablo on this one.
>
>
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>
>On 2 Jun 1997, Pablo Sanchez wrote:
>
>}
>} In article <01bc6e57$5fdd9ae0$618285ce_at_ian>, "Ian Sparkes"
 <sparkes_at_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_at_pager.sgi.com
>} --------------+-----------------+--------------------------------------------
>} pablo_at_sgi.com ... when mailing me, place "not spam" in the Subject
>}
 

-- 
David Williams
Received on Mon Jun 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US