Querying Relationships and Eager Vs Lazy Loading

Hi laariane, great question!! Yes, n+1 is still possible, though unlike with other ORMs that offer auto lazy loading by reference since the loading is explicit with Lucid the n+1 issue becomes a little easier to spot.

For example, here's a n+1 query using Lucid's lazy loading

const movies = await Movie.all()

for (let movie of movies) {
  // will loop through each movie and 
  // individually query each movie's director
  await movie.load('director')
}

  

    

      Copied!
      

        

      
    
  
  
    
    
    
    
  

This n+1 can be solved by switching to preloading or querying a list of directors rather than individually loading.

const movies = await Movie
  .query() // still queries all movies since we aren't filtering at all
  .preload('director') // loads director info without n+1

  

    

      Copied!