To have a default scheduled task where it will purge the expired workflow data based on the 'Number of days' configured in Preside

Description

As workflow table keeps growing due to high traffic, possible cause by:

  • User not finishing event booking journey

  • User not finishing join online journey

  • etc
    Niall has suggested that, we could probably build a scheduled task where it will purge the expired workflow data based on the Number of days configured in Preside.

Suggestion/Work to be done:

Suggestion

So, my advice would be that...there is an expires column on the workflow table, as well as the datecreated and datemodified, so I would suggest is that there is a job that runs nightly to purge anything with an expiry over a certain threshold that has not also been modified in the same period.

The period can start with something like 1 Year, as suggested, but modified if the tables still breach our thresholds.

It would be nice to have the "Number of days" over which to purge value in the CMS for configuring too so it can be easily adjusted to suit.

Assignee

Unassigned

Reporter

Chun Weng Wong

Labels

None

Accepted

None

Fix versions

Priority

Low
Configure