Re: Slightly-OT: Throw HW at a SW/DB problem
Date: Mon, 27 Jun 2011 17:06:21 +0200
Message-ID: <4E089C6D.4050703_at_roughsea.com>
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
>
> --
> http://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> -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 27 2011 - 10:06:21 CDT