Re: Benchmarking Oracle on 2-processor HyperSPARC

> Does anyone on the net have a set of appropriate benchmarking tests
> ... that shows the superior performance of the multi-processor HyperSPARC
> module as compared to a single processor system?

i'm afraid i don't, but i've been looking for a cheap excuse to explore this issue in this forum. thanks. :-)

it's not obvious to me that an SMP (i.e. shared-memory) box ought to perform that much better for simple queries like, say,

   SELECT * FROM tblMy5GigTable WHERE intMyMagicCookie = 12345 ; .

one of the claims one can read in the marketing literature is that such a query can be distributed across a gang of processors, with each one scanning a part of the large table. it seems to me that the processors will occupy themselves more with fighting for the memory bus than actually doing work. i wonder if many of these oracle SMP boxes aren't just really really expensive heaters.

if one were doing queries like this, on the other hand:

   SELECT * FROM tblMy5GigTable WHERE

      myComplicatedFunction(intMyMagicCookie) = 23456 ;

i can see the opportunity for parallelization.

does this thinking make sense?

is all. Received on Sat Jul 13 1996 - 00:00:00 CEST