Graphql query performance optimization | Community
Skip to main content
ravir73578276
ravir73578276
Level 3
April 6, 2023
Solved

Graphql query performance optimization

  • April 6, 2023
  • 2 replies
  • 3805 views

I am using Graphql on AEM 6.5 to get the content-fragments. I have a  high number of Content Fragments that share the same model due to which the graphql list query has become really slow. How can I improve the performance of graphql query in AEM ? 

Note:- I am already using the persisted grahphql query and chaching it. But the initial load of the query results is really slow before it gets chached.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by krati_garg

@ravir73578276 Can you share the statistics?
-GraphQL Query
-Result Count

-Time Taken for query response

-Explain Query Screen shot, when you say correct index is being picked up.

2 replies

Saravanan_Dharmaraj
Community Advisor
Saravanan_DharmarajCommunity Advisor
Community Advisor
April 6, 2023

@ravir73578276 Please use Explain query tool and see which index is using or is it traversing without index. Please see the related post on indexing and indexing will help in speeding up the query performance

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/issue-with-indexes-with-graphql-apis-queries/td-p/558991

 

    ravir73578276
    ravir73578276Author
    Level 3
    April 6, 2023

    It is picking up the correct index. But I don't see significant improvement in query performance.

      krati_garg
      Adobe Employee
      krati_gargAdobe EmployeeAccepted solution
      Adobe Employee
      April 6, 2023

      @ravir73578276 Can you share the statistics?
      -GraphQL Query
      -Result Count

      -Time Taken for query response

      -Explain Query Screen shot, when you say correct index is being picked up.

        P
        Preston-3
        Level 4
        December 9, 2023

        Can you advise how you get statistics in AEM on GraphQL query performance? I can't see anything in the Query Recorder to grab onto, nor in the Query Performance tool. 

          P
          Preston-3
          Level 4
          May 22, 2024

          I'm still wondering about this. 

           

          Anything, @krati_garg ?

            Terms & ConditionsAccessibility statement

            Loading footer...