Re:SQL queries don't start with SELECT
by tomnipotent on Thursday October 03, 2019 @09:06PM
(#21153934)
Hidden side effects. Iterating over a list of something in one layer shouldn't trigger database queries in another.
Ideally, you should know ahead of time what data you need and how to pre-load it without relying on something that could cause multiple N+1 issues based on the depth of lazy loading.
What is wrong with lazy loading enabled by default?