Graphql query performance optimization

Forum|Forum|2 years ago
April 6, 2023
2 replies
3786 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.

krati_gargAccepted solution

Employee

@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

New Participant

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

New Participant

I'm still wondering about this.

Anything, @krati_garg ?

Saravanan_Dharmaraj

New Participant

@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

ravir73578276Author

New Participant

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded