back to article Rapping otters and automated database knob-twiddling: An obvious combination in some universe or other

A university spin-out startup has announced a private beta of an automated database tuning service which its founder claims can double the performance or halve the cost of the popular AWS Relational Database Service. Among its marketing hype, though, is the, erm, novel approach of launching a hip-hop album of beats and …

  1. Doctor Syntax Silver badge

    Before twiddling the engine parameters start by looking at the actual queries and query plans they generate. A few bad ones will eat up far more resources than you'll ever get back from tuning.

  2. yetanotheraoc

    Sure, but

    "A few bad ones will eat up far more resources than you'll ever get back from tuning."

    Apart from, as mentioned in the article, some places don't want you knowing about their queries; there is also the fact that poor performance could be either the overall database or the individual queries. So if you tune the database in some reliable way, and the application still performs poorly, then you know it's the queries. Of course it almost always is the queries, but the same people who are resistant to writing good queries are incredibly resistant to making bad queries better. One team I was on, the most experienced guy always copy/pasted the *exact same* hints at the top of *every one* of his select statements -- even across databases. I think he just wanted management to believe he had done some tuning. At least after applying the OtterMation management knows where the problem lies.

  3. Gene Cash Silver badge

    There's a new sentence

    "it does databases but also there's the record label and then there's a clothing line"

  4. TeeCee Gold badge

    French bank Societe Generale.

    They probably like the fact that a piece of software is far less likely to take its knowledge of the IT systems, move to the trading side of the business and drop them in a huge pile of poo.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Biting the hand that feeds IT © 1998–2021