Yet it’s the sysadmin who gets blamed, not the developer. “How can you tune the database so this doesn’t happen?”
I am telling you this because hopefully it will make you feel a little better. Our head of it blames devs for slow queries.
Devs who don’t understand how SQL or relational databases work write absolute abortions of queries.
9 times out of 10 - yes it is absolutely the devs. I say that as the dev who gets tasked with analysing why these shitty queries from our low budget outsourced labour are so slow
So you are saying you are the expert in unshitifying queries? What is the most common thing that needs to be unshitified?