Re: Performance

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 16 Sep 2006 05:54:43 -0700
Message-ID: <1158411279.487168@bubbleator.drizzle.com>

Frank van Bortel wrote:
> Jack schreef:
>

>> Surely tuning migth give 5-10% or more and maybe CBO that same,
>> but not 500-1000%

>
> 1000% = factor 10. I've seen factor 40 by just rewriting statements.
>

>> But best and cheapest way wuold be upgrade and new hardware.

>
> In the light of the above, did you still believe that? Oh sure,
> it's the easiest way, and it actually will bring something, so
> it's also a safe way.
> Just like "nobody ever got fired because they advised BB"
>
> Tune. And upgrade, so your test and production at least run
> the same versions

I have many times seen factors of 50-100X.

Anyone that suggests solving a problem by throwing hardware at it is living in the 1980s to early 90s. The problems today are almost always related to architecture and design.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Sat Sep 16 2006 - 07:54:43 CDT