GraphQL - Famous N+1 query issue

[Matthew Henry]

Hi,

I'm facing GraphQL (N+1) query problem and it is been clearly explained in the video https://www.youtube.com/watch?v=ld2_AS4l19g&ab_channel=knowthen on how we can solve the problem.

However not sure on the following, Please help me with source code if possible, Thank you so much in advance.

Books returns 4 and query executed 4 times
User returns 8 and query executed 8 times
Department returns 4 and query executed 4 times

only one difference at the end of the schema it is defined as BooksPaged! similarly for others as well

In my Case
a. Books
b. Users
c. Department

query {
 books{
 total  
  users {
    total
    department{
        name
     }
 }
  }
}

Thanks