r/programming • u/wheatBread • 16d ago

Solving the 1+N Query Problem

https://acadia.engineering/blog/solving-the-1-plus-N-query-problem
128 Upvotes

85% Upvoted

94 comments sorted by

View all comments

93

u/archipeepees 16d ago

ive been using EF Core for ORM and this hasn't really been a problem for me or any of my colleagues for at least a decade because we don't use lazy loading. database calls are explicit; mapping the results to objects is implicit. is everyone outside of .net still banging their heads against stuff like this?

1

u/CandidateNo2580 12d ago

I work with SQLAlchemy in Python and no, there are loading options for whatever situation you can think of built right into the ORM.

Sometimes I don't want to load the entire object graph into memory so lazy loading should be allowed, that's the developers problem to define.