Hi Team,
I am seeing a lot of slow queries in my AEM 6.2 author instance lately. We did in-place migration from aem5.6.1 to AEM6.2.
Most of them are related to the evnt Jobs /jcr:root/var/eventing/jobs//element(*,slingevent:Job)[@event.job.topic = 'com/day/cq/replication/job/publish1' and not(@slingevent:finishedState)] order by @slingevent:created ascending.
How Can I create an index in oak for these or what is the best way to improve this?
Thanks In Advance.
Views
Replies
Total Likes
Hi,
please get in touch with Adobe AEM support and request a set of optimized index definitions (and how to apply them safely), which will help in this case.
Jörg
Forgot to mention: I point to support, because it is a known issue and there is already a solution available for it. And as the query is being caused by the product itself, you cannot change the query itself.
Jörg
Hi Jorg, what is the solution and where can I find that solution?
Thanks In Advance
As said, please contact support!
Jörg
Hi Jorg,
I got it. I will open a ticket with support.
Thanks:)
Views
Likes
Replies