A question about AEM performance, particularly workflow related activities, including usability of the Workflow Admin interface.AEM 6.2 seems to disable by default the event.job.topic property index (/oak:index/event.job.topic). The intent SEEMS to be to replace this with the slingeventJob (/oak:index/slingeventJob) index.However, as the volume of workflow data grows in a high volume environment the slingeventJob index under performs the old property index by an order of magnitude. Cost of the p...

AEM 6.2...I would like to identify nodes in the DAM which may have been missed by a disabled DAM Update Asset workflow. These nodes would be missing a child metadata and/or renditions.Executing the following two queries returns identical results:1) SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE([/content/dam/])2) SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE([/content/dam/]) and [jcr:content/metadata] is nullThe null check does not appear to be respected.The following query return...

We have an AEM 6.1 SP1 sites deployment where we are seeing exceptionally poor search performance using the OOTB /libs/foundation/components/search component.The initial search is slow against a very small hierarchy of pages. It returns less than 20 results (in one example) which is paged 10/page. When navigating / paging back and forth between page 1 and 2 of the results we see significant spikes in CPU usage from 5% up to over 150%. Additionally, memory usage seems to climb slightly with each ...