today i was dealing with some degraded database performance at work.. and i made the cardinal mistake of not going in to measure and monitor before diving into the code.
in a bout of hubris, delusion, and laziness (?), i assumed i already knew the culprit and directly started attacking my target.
and i demolished my target. i changed the approach of the query, sped up the whole thing and.. sure... it was some good work.
but it turned out to be the wrong target; the database was still huffing and puffing.
so after my colleague prodded me, and prodded me some more.. i finally checked the measurements and to my surprise it was a totally different query slowing down the circus.
i was super wrong... after shaking off my mistake i tackled the actual issue and soon the database was purring in contentment again. and me... i promise i will measure again sensei.