As workflow table keeps growing due to high traffic, possible cause by:
User not finishing event booking journey
User not finishing join online journey
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:
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.