Here's a game I like to play when someone tells me they "optimized" something... I ask them what they gave up for the optimization???
Nobody ever has a clean answer. That's the tell.
Optimization doesn't cancel cost, it moves it. You're not making a system better, you're picking which axis gets to suffer instead of another. The engineers who ship the most reliable systems aren't the ones who found the mythical zero-tradeoff solution. They're the ones who knew exactly which axis they were sacrificing, and chose it on purpose instead of by accident.
A few trades most of us make without saying the price out loud :-

Cache it :- You just traded correctness for speed. Every cache is a bet that staleness won't matter before the next invalidation fires. Sometimes that bet is free money. Sometimes it's how a user sees someone else's account balance for four seconds.

Add an index :- Reads get fast. Writes get slower, forever, because now every insert updates the index too. Storage grows quietly in the background until someone asks why the disk bill tripled.

Go optimistic on locking :- Throughput goes up when conflicts are rare. But when they're not rare, you're paying it all back in retries and wasted work, and the system gets slower under the exact load where you needed it fast.

Retry on failure :- You just traded a clean failure for a delayed one. The retry that saves one user during a blip is the same mechanism that turns a partial outage into a full one, once enough clients retry into an already-struggling service at the same time.

Cut the monolith into microservices :- You traded deploy coupling for network calls. Every function call that used to be free is now a request that can time out, and every bug that used to live in a stack trace now lives in three services' logs at once.
None of these are mistakes. They're all correct decisions, made by people who understood the price. The mistake is doing any of them because it's the "best practice," without ever asking what you just agreed to pay.
So next time you optimize something... don't ask if it worked. Ask what it cost, and whether you'd have paid that price on purpose???

What's the trade you made on purpose (or didn't realize you'd made) that taught you the most?