News for hackers. Stuff that matters.
Re:How I Reduced My DB Server Load by 80% by porker on Monday October 09, 2017 @12:49PM (#15435420)
> Exactly why ORMs are a bad idea

I'm not a full-out fan for ORMs but... this is not an ORM issue. It's an issue with an ORM of the ActiveRecord variety that pushes database-logic back to code level for some strange reason. The ORM I'm most familiar with (Doctrine2, Object Mapper pattern) doesn't do this. It does other weird stuff, but not this.

Re:How I Reduced My DB Server Load by 80% by Semiapies on Monday October 09, 2017 @04:07PM (#15437031)
Just so. SQLAlchemy and many other ORMs allow you to simply define an index. ActiveRecord always reimplemented far too much of the database. I'm not sure whether that was due to the state of MySQL functionality at the time or what.