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
4 months agoAnnabelle
4 months agoGeraldine
4 months agoCecily
4 months agoPilar
4 months agoAllene
5 months agoViki
5 months agoKatina
5 months agoMatilda
5 months agoJade
5 months agoNobuko
5 months agoPatti
5 months agoGlory
5 months agoKenneth
5 months agoBeckie
1 year agoMary
12 months agoJackie
12 months agoLeota
1 year agoGoldie
1 year agoMisty
1 year agoMarci
1 year agoOnita
1 year agoJeffrey
1 year agoLigia
1 year agoNatalya
1 year agoShantell
1 year agoDana
1 year agoTalia
1 year agoGerald
1 year agoAdrianna
1 year agoEvangelina
1 year ago