Question: N + 1 Query issues

[MikeAliG]

Hello,

This is a great package and thanks for creating this awesome package, now my question is that, does this package handle N + 1 Query issues?

Thanks a lot in advance.
Ali

[AhmedElywa]

The main thing we create this package is facing N + 1 query issue in my private project
Idea here is convert info: GraphQLResolveInfo that has query fields come from frontend to be available prisma select object

Example query

query {
  findOneUser(where: { id: 1 }) {
    id
    email
    name
    posts(
      where: { title: { contains: "a" } }
      orderBy: { createdAt: asc }
      first: 10
      skip: 5
    ) {
      id
      title
      comments(where: { contain: { contains: "a" } }) {
        id
        contain
      }
    }
  }
}

convert to

{
  select: {
    id: true,
    email: true,
    name: true,
    posts: {
      select: {
        id: true,
        title: true,
        comments: {
          select: { id: true, contain: true },
          where: { contain: { contains: 'a' } }
        }
      },
      where: { title: { contains: 'a' } },
      orderBy: { createdAt: 'asc' },
      first: 10,
      skip: 5
    }
  }

with this way you just query what the frontend ask and save your performance
and don't do a lot of findOne for every relation result

old way

In this query example if we have result with 10 users so i was doing 10 queries prisma.post.findMany and for every post result i will do prisma.comment.findMany so this arrive with me in some cases to 850 query in one request take 40 second

my way

convert info to be available prisma select object you will do one query to get all what you need the query was take 40 second before now take less than 100ms

I hope i made it clear

[MikeAliG]

Hello,

Very interesting! Thanks a lot for clearing that up. Is it possible to give an example for converting info to be available prisma select object (your suggested way)?

Thanks a lot in advance!

[AhmedElywa]

It's already in my tools https://github.com/AhmedElywa/prisma-tools/tree/master/packages/select
you can download my examples and try it

[AhmedElywa]

@AliTheAli you can use this one https://github.com/AhmedElywa/prisma-tools/tree/master/examples/apollo-nexus-schema

[MikeAliG]

This is great! Thanks a lot for all your amazing work!

[nghiepdev]

I just wanted to say thank you for creating the Prisma Select!

[AhmedElywa]

@nghiepit Thank you for your positive feedback

[ielireb]

I have trouble with @@id. its giving me error.