SOLVED
AEM Headles GraphQL query slow
version: 6.5.17.0
method: Content Fragment GraphQL APIs
Use different folders to differentiate languages, a total of 1452 records (En: 726 records, ZH-HK: 726 records).
Query:
query queryAllADOForms($lang: String!) {
adoFormsList(
_locale: $lang
) {
items {
_path
name
formName
formCode
formCategories
formPurpose
attachment {
... on DocumentRef {
_path
}
}
hiddenSearchableField {
plaintext
}
additionalViewersWhenPublished
expiryDate
lastModified
}
}
}
execute query:
Usually 10 seconds, sometimes longer.
Are there any ideas to improve the efficiency of the query?
1 Accepted Solution
Correct answer by
You can do the following:
1) Check the query is performant, make sure this has an index.
2) Make sure this is being cached and check the performance against a cache layer
3) Analyze if you have the chance to use paging to reduce the initial result set
Check these recommendations which can help as well:
Esteban Bustamante
hello @darrendu
If you are on AEM on-premise, please refer to latest release notes. It suggests to install a graphql index package for better performance
Once this is done, please check for the logs for any traversal messages,while executing GraphQL queries. If any custom property, ordering etc is used, please consider optimizing indexes.
Aanchal Sikka
Correct answer by
You can do the following:
1) Check the query is performant, make sure this has an index.
2) Make sure this is being cached and check the performance against a cache layer
3) Analyze if you have the chance to use paging to reduce the initial result set
Check these recommendations which can help as well:
Esteban Bustamante
