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: Microsoft destroys TPC-C records!

Re: Microsoft destroys TPC-C records!

From: Larry <lsedels_at_us.ibm.com>
Date: 2000/03/01
Message-ID: <38BDCCC6.DA3277AD@us.ibm.com>#1/1

Yes, DB2 UDB EEE.

Norris wrote:

> May I know if there is any other similiar RDBMS implementation like the SQL 2000's "Shared Nothing" technology?
>
> In comp.databases.sybase Serge Rielau <srielau_at_ca.ibm.com> wrote:
> > Shared nothing referes to system resources only.
> > Versus shared everything or shared disk.. and so on.
> > The trick is to minimize the network-traffic and the one there is,
> > better be fast.
> > There are certain types of queries that are more applicable for
> > parallelization
> > than others and it is also important to decide in how far it makes sense
> > to e.g.
> > replicate data on versus nodes.
> > Scalability is not automatic. It depends heavily on the quality of the
> > optimizer,
> > the DB schema, infrastructure and the nature of the query.
> > E.g. an insert of one row will not run faster by adding more machines.
> > A select count(*) from t on a nicely partitioned table however will
> > scale very well.
 

> > Just my two cents
> > Cheers
> > Serge
>
> --
> JULY
Received on Wed Mar 01 2000 - 00:00:00 CST

Original text of this message

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