News for hackers. Stuff that matters.
Re:How not to structure database-backed web apps: performanc... by danielbarla on Thursday June 28, 2018 @07:43AM (#17416030)
I agree that this has more to do with the developer than the ORM. I once watched someone write a foreach loop around a set of millions of records, to update their "BatchDate" property to the current date / time. To add insult to injury, to get the current time, they issued a separate query to the DB, in the form of "SELECT GETDATE()", then injected the result - as a string - into the update statement.

To be fair though, ORMs do move us one layer further away from the actual DB, so people tend to be even less likely to understand how to write ORM calls which result in performant SQL calls.

There are no comments on this comment yet.