Graphql query performance optimization

[ravir73578276]

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.

[Saravanan_Dharmaraj]

@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-gr...

[ravir73578276]

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

[krati_garg · Accepted solution]

@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.

[Preston]

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.