Re: Memory Sizing Advice

From: Frank van Bortel <>
Date: Fri, 16 May 2008 09:58:40 +0200
Message-ID: <a5537$482d3eb0$524b5c40$>

Helma wrote:

> The old machine was a 1 CPU machine. There was an increase of
> performance between 0 to 2 % (if i remember well) , instead of the
> 800% the CEO expected.
> So if you want to try the RAM scenario, do as you please. But please
> measure your performance in response times, and not some hitratio. And
> then have a look at the difference in performance.
> H.


And there's a bug in 9.2 (patch 6, iirc, and it was HP specific) that will send your response time skyhigh, because the optimizer keeps looping the huge buffer - it simply does not understand searching memory for 6 hours is *not* faster than giving up after 1 second, and fetching from disk - although it may be "cheaper".

FvB Received on Fri May 16 2008 - 02:58:40 CDT

Original text of this message