Find qraphql performance issues

wiesson2 years ago

7

{
  Hotels(locale: ${locale}, where: { _status: { equals: published }}, limit: 1000) { docs { id slug updatedAt } },
RoundTrips(locale: ${locale}, limit: 1000, where: { _status: { equals: published }}) { docs { id slug updatedAt } },
  Blogs(locale: ${locale}, limit: 1000) { docs { id slug title content meta { title description } imageSrc image { id cloudPublicId alt slug } } }
},

• 

  grandnainconnu2 years ago

  Have you tried making 3 separated parallel requests? Or it's maybe not possible in your case?

• 

  wiesson2 years ago

  It is possible, I thought it might be faster in one go 🙂

  
  
  

  Let me try

• 

  grandnainconnu2 years ago

  I don't know how the resolvers handle multiple collections queries in one go, maybe it isn't async between each other that could cause a long delay

• 

  wiesson2 years ago

  getStaticSitePathsByLocale Hotels: 126.58ms
  getStaticSitePathsByLocale RoundTrips: 104.384ms
  getStaticSitePathsByLocale Blogs: 6.577s

  
  
  

  Do you know if I can do "raw" mongodb queries?

  
  
  

  I'd like to select only what I need. I assume that payload.find selects every field of the collection and I'd like to optimize here a bit

  
  
  

  /answered

  
  
  

  /done

  
  
  

  /fixed

• 

  grandnainconnu2 years ago

  Yes you can! You have to get the model through payload collections

  
  
  

  payload.collections['yourCollection'].Model

  
  
  

  6 secondes for 1000 documents seems a bit long though, maybe check what the actual resolver performs

  
  

  Or you can integrate your own:

  https://payloadcms.com/docs/graphql/extending
  
  

  Btw, if it's to generate static paths, you could try to see to make some kind of loop/pagination system, to avoid querying everything at once

• 

  wiesson2 years ago

  ah perfect - so like this:

  
  
  

  // executes, name LIKE john and only selecting the "name" and "friends" fields
  await MyModel.find({ name: /john/i }, 'name friends').exec();

• 

  grandnainconnu2 years ago

  yes you can execute any raw query or map it as a resolver and use it in GraphQL