Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Oak indexing query(after migration)

amrit1993
Level 3
Level 3

Hi all,

We have migrated a website from cq 5.4 to AEM 6.0. After migrating our mails(registration mails used by user) are getting delayed. The error being thrown is 

WARN* Traversed 1000 nodes with filter Filter(query=select ...) consider creating an index or changing the query

Got this from the documentation:

Unlike Jackrabbit 2, Oak does not index content by default. Custom indexes need to be created when necessary, much like with traditional relational databases. If there is no index for a specific query then the whole repository will be traversed. The query will still work but probably be very slow. 

How to create an index such that it will only traverse to check whether the record of the user already exists and not traverse the whole repository.

Thanks upfront for the help. 

Update: SELECT * FROM nt:unstructured WHERE jcr:path LIKE '/home/users/%%/profile' AND email='%s'

this is our query where email is dynamic.

0 Replies