What's worse than an N+1: Accidental Cartesian Products

returnzero.win

3 pointsevnix2 comments

Are any places or projects using ORMs where performance is a key need? Is instagram using it with their Django app?

Don’t get me wrong totally get the benefit of not having to serialize and deserialize to and from SQL to objects in your favorite language but hot damn for something that is so clearly designed to make cognitive dissonance a thing of the past they sure do so at the cost of a lot of performance.

true, from what I've seen, people use it for convinience, ORMs do always have an escape hatch to use raw SQL, and some do allow mapping raw SQL to objects.

Reply on news.ycombinator.com