4 ms·
A client of mine is enduring growth induced ORM hell right now. The struggle and existential threat is real. It can take days for them to even track an evil SQ
by Nihilartikel 3y ago
A client of mine is enduring growth induced ORM hell right now. The struggle and existential threat is real.
It can take days for them to even track an evil SQL query back to the actual code. There were fetch-one calls that literally carry a million rows back over the wire for that one returned entity. Indices get skipped due to the magic translation of a row.col.toUpper()=="STRING" into SQL.. when the db collation is case insensitive in the first place.
But hey, the devs don't need to know SQL, so there's that.
- renegade-otter 3y agoThe solution is to go "web scale" and add a technology with magical indexes and no transactions because IT FAST! What could possibly go wrong.
- Nihilartikel 3y agoWell, I have heard the word 'Mongo' uttered in passing....