A customer is having trouble with some search queries and provides the following information:
* The logs show the following warning occurs many time: WARN* Traversed 1000 nodes with filter Filter (query=select...)
* The client has more than 100,000 stored in their AEM instance
* The client uses a custom page property to help search for pages of a given type
What should the AEM Developer do to help resolve the client's issue?
The warning WARN* Traversed 1000 nodes with filter Filter (query=select...) indicates that the query is performing a traversal instead of using an index. This results in poor performance, especially when the client has a large number of nodes (e.g., more than 100,000).
To resolve this issue, you should create a custom Oak index for the custom page property. This ensures that the queries can leverage the index for efficient data retrieval.
Steps to create a custom Oak index:
Define the Oak Index:
Navigate to the /oak:index node in CRXDE Lite (http://localhost:4502/crx/de).
Create a new node of type oak:QueryIndexDefinition.
Configure the Index:
Set the properties of the new index node to define the indexing rules for the custom page property.
{
'jcr:primaryType': 'oak:QueryIndexDefinition',
'type': 'property',
'propertyNames': ['customPageProperty'],
'reindex': true,
'async': 'async'
}
Deploy and Reindex:
Save the changes and initiate a reindexing process.
Ensure that the reindex flag is set to true for the newly created index.
Validate the Index:
Use the Index Manager or the AEM Web Console to validate that the new index is enabled and functioning correctly.
By creating a custom Oak index for the custom page property, the queries will be optimized to use the index, significantly improving the search performance and resolving the client's issue.
Vanda
10 months agoAnnabelle
10 months agoGeraldine
10 months agoCecily
10 months agoPilar
10 months agoAllene
11 months agoViki
11 months agoKatina
11 months agoMatilda
11 months agoJade
11 months agoNobuko
11 months agoPatti
11 months agoGlory
11 months agoKenneth
11 months agoBeckie
2 years agoMary
1 year agoJackie
1 year agoLeota
2 years agoGoldie
2 years agoMisty
2 years agoMarci
2 years agoOnita
2 years agoJeffrey
2 years agoLigia
2 years agoNatalya
2 years agoShantell
2 years agoDana
2 years agoTalia
2 years agoGerald
2 years agoAdrianna
2 years agoEvangelina
2 years ago