Review and Test Scheduled Batch processing against a large repository

Context

We have inside the platform some default scheduled jobs that involve processing a potentially large amount of documents:

• OrphanVersionCleanupListener
• EscalationRuleWork
• DocumentRoutingWorkflowInstancesCleanup
• RetentionExpiredFinderListener
• ...

At least some of them are problematic with large repositories because they create long queries and/or long processing.

It seems that support can sometimes recommend disabling them (i.e. see SUPNXP-29143).

Tasks

I am not sure we want to include testing WF or Retention in the context of the benchmarks, however, we could:

• extract queries and run them against large repository
  • see if this creates issues
  • see if indexes can help
  • see if we need to redesign the query
• extract the potential big processing
  • see if this creates issues
  • see if moving to BAF would help