RE: Slightly-OT: Throw HW at a SW/DB problem

From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
To: "'sfaroult@xxxxxxxxxxxx'" <sfaroult@xxxxxxxxxxxx>, "rjoralist2@xxxxxxxxxxxxxxxxxxxxx" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 27 Jun 2011 12:45:55 -0400

Stephane hit on the head. Bad code will always trump the HW not matter what. 
And there's lots of it. Case in point for me was playing with some ssd - reads 
were great as long as it was full table scans or very simple joins but when we 
got into multi-joins and complex queries that's where we got into the real work 
 - and HW can't help you with that.

________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Stephane Faroult
Sent: Monday, June 27, 2011 11:06 AM
To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
Cc: ORACLE-L
Subject: Re: Slightly-OT: Throw HW at a SW/DB problem

On 06/27/2011 04:45 PM, Rich Jesse wrote:

I think I'm gonna be sick:



http://www.sqlmag.com/article/Performancetuning/ssds-performance-tuning-experts-milkman-139591



This mentality **in a database professional** completely escapes me.  It

brings to mind that I just "upgraded" my Blackberry to one that has 2x the

CPU and 5x the RAM -- and still works just as bad as the one it replaced (if

not worse).



Anyone from the Oracle camp advocating/predicting hardware-based "tuning"?



Rant over.



Rich



--

//www.freelists.org/webpage/oracle-l






Rich,

  Never underestimate bad developers. They can beat hardware anytime.

And to put some balm on your wounds, I have recently posted this on Youtube 
http://www.youtube.com/watch?v=5WPOUvzyLjc -
partly as an answer to the (very well done by the way) Oracle Exadata video.

Don't read me wrong: there are obviously cases when powerful hardware, Exadata, 
SSD, you name it, is required. But well, not THAT often. At least, not as often 
as hardware providers pretend.

Reminds me of an application I have audited that was taking I think 1h15 to 
generate a 70 page report (on a reasonably sized Sun server). The vendor's 
answer was "upgrade the hardware". However, the rep made a big mistake: he run 
the app on his own laptop and it actually run faster. It made the customer 
suspicious. As it was a canned app, I switched a 10046 trace - couldn't edit 
the .trc and I had to grep my way into it. 600,000 queries in the trace file.

Try to beat this with hardware.
--
Stephane Faroult
RoughSea Ltd<http://www.roughsea.com>
Konagora<http://www.konagora.com>
RoughSea Channel on Youtube<http://www.youtube.com/user/roughsealtd>

NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, please go to www.td.com/legal 
for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. 
Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière 
d'aller au www.td.com/francais/avis_juridique pour des instructions.

References:
- Slightly-OT: Throw HW at a SW/DB problem
  - From: Rich Jesse
- Re: Slightly-OT: Throw HW at a SW/DB problem
  - From: Stephane Faroult

RE: Slightly-OT: Throw HW at a SW/DB problem

Other related posts: