Ability to automatically or en mass trim old Workflows

[Piedone]

Is your feature request related to a problem? Please describe.

Executing a Workflow Type creates a Workflow document, and a corresponding WorkflowIndex. Unless you delete Workflows manually (either one by one, or in bulk page by page), this causes both the Document and the WorkflowIndex table to grow indefinitely.

This becomes a real issue if workflows are executed frequently. E.g., the site of one of our client uses Workflows to handle form submissions, which forms are submitted by thousands of people every workday. The result is that the Document table is now 12 GB with 860k rows, and the SQL query behind /Admin/Workflows/Types (SELECT DISTINCT [WorkflowIndex].[WorkflowTypeId] FROM [WorkflowIndex]) times out, resulting in an error page.

Related to #6056.

Describe the solution you'd like

A feature that would periodically delete Workflows older than a given threshold, much like Audit Trail trimming works, would be ideal.

This needs special care and batching, since there can be a huge number of Workflows (860k for us), especially the first time it runs.

Describe alternatives you've considered

The ability to delete Workflows en mass mass, more than just 10 items on a page.

[github-actions]

We triaged this issue and set the milestone according to the priority we think is appropriate (see the docs on how we triage and prioritize issues).

This indicates when the core team may start working on it. However, if you'd like to contribute, we'd warmly welcome you to do that anytime. See our guide on contributions here.

[deanmarcussen]

possibly duplicate of #11609

We actually wrote this internally (pruning/trimming), and have been wanting to pr it back.

With any luck that might actually happen soon

[Piedone]

That would be awesome!