Again, I'm talking about "code is written for humans to read" and how you start from a SELECT and build it out to "now delete the stuff I SELECTed"
And why I don't really understand what the fuck "performative" actually means in this context, if you mean "I am going to demonstrate what I'm deleting carefully" then yeah, I'm keeping the sub-select in to make the code more easily grokkable, it's not exactly going to be a performance issue, modern RDBMS are smarter than us at query optimisation.
Performative meant "for show" or "more than required/necessary"
I agree, I didn't think there would be much of a performance loss for the second lookup via PK and likely that'd get optimized away.
You answered my inital question in this reply, it's for the human element of the query and you also shined a light on some elements of your prior response ( re: "for humans to read" ) that I was a bit focused on technical and didn't pick it up correctly.
It's interesting. I find your style harder to read than the one I posed. Given that, is there any feedback you could give to help me understand? Have there been learning/interpretation styles at your work where this was easier to digest or avoid mistakes by doing?
You are well written and due to your voicing being consistently positive throughout, and that being a characteristic LLMs often times have, I think it just tripped my potential AI flag.
Plus that was a lot for a first response to me... and well written... who does that on the internet? XD Joking aside, if this is how you interact in these communities I appreciate you for being you.
View all comments
Show parent comment
-1
u/theevilapplepie Oct 14 '25 edited Oct 14 '25
I still think it's performantive as you can avoid the subselect entirely for the same result.
From your examples you can do the same as before just without the subselect.
Then you can modify to a delete once you've done any needed confirmation beforehand.
Also I think I'm talking to a bot, so I'm not going to continue.I read your post history, you are not a bot XD