Re: L2 cache vs. faster processor

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 14 Jul 2004 16:01:07 -0700 (PDT)
Message-ID: <20040714230107.20588.qmail@web20423.mail.yahoo.com>

• Terry Sutton <terrysutton_at_usa.net> wrote:
  > A client is ordering hardware for an Oracle on Linux
  > system, and has to choose between 2.8 GHz Xeon
  > processors with 1MB L2 cache and 3.06 GHz Xeon
  > processors (no L2 cache). Does anyone have any
  > recommendations on the value of L2 cache vs. a
  > faster processor?
  > --Terry
  

Intel has some docs related to this up on their website.

back in the days of the PIII Xeons, the 2 MB cache 900 MHz was 15% faster.

Today, they compare the 4 MB L3 cache (not L2, I believe) as being 30% faster than the 1 MB L3 cache model.

if you're processing nested loops code (such as Connor's achieve a stated buffer cache hit ratio loop) the larger cache would probably win.

signing off, losing network.

Pd

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 14 2004 - 17:57:44 CDT