Re: Performance difference between 2 machines

From: Etunimi Sukunimi <etunimi.sukunimi_at_sonera.com>
Date: Tue, 21 Jun 2005 09:20:52 GMT
Message-ID: <UZQte.63$N23.19@read3.inet.fi>

Noons wrote:

> Joel Garry wrote:
>
>

>>There's something I'm missing here.

>
>
> Same here. Isn't the 9k/800 massively slower in CPU than
> a P4 2.8GHz? I seem to recall the 9K/800 being a few years
> old technology? That would certainly help explain a big difference
> in speed like that. Apart from the block sizes as already talked
> about.
>

But wouldn't the trace file output suggest that the processors are waiting for something?

Remember that the sql-command given was "select count(1) from TABLE_A", that doesn't really need that much of processing power.

G: Mikael Received on Tue Jun 21 2005 - 04:20:52 CDT