[mdlug] L1 & L2 Cache AMD & Intel

[Aaron Kulkis]

Dan Pritts wrote:
> On Tue, Feb 19, 2008 at 01:31:38PM -0800, David Lane wrote:
>> The Next resource I'm looking it is a database server (MySQL)/Intranet HTML server .
>>
> 
> VERY broadly speaking, for most DB applications, if you have to
> choose between CPU cache and more main memory, choose more main
> memory.



> 
> Next (or perhaps *before* main memory) choose faster hard disks,
> and/or a faster RAID controller.

Depending on the size of the database and other running apps,
and how much memory can populate the motheroard.

If the database is small enough to all fit in RAM with all of
the other processes that will be running, then buy enough RAM
to do exactly that.

If not, then buy fast disks

> 
> If you're sure you'll have enough main memory & fast enough disks,
> more CPU cache can't hurt.  
> 
> Probably, though, a better buying strategy would be to try your
> application on the hardware you already have and see where the
> bottleneck is.
> 
> danno