...
The purpose of the "Archive Process On Completion" feature is for faster performance when Joget works with the SHK process tables for active processes, by keeping the main SHK tables "small". Process archiving on completed processes "moves" the process records to the following DB tables: wf_history_activity, wf_history_process, wf_process_link_history. The archived processes are still accessible in the "Admin Bar > Monitor screen" or via database queries on the above process history tables.
Latest updates/changes (since 8.0.10):
- Joget uses an internal setting to keep track of the archiving status.
- The "Archived Processes" page will display the archive progress and have a new button to pause and resume the process migration.
- Will run the migration thread with a batch of 10 processes.
- When the migration status last run is longer than 15 minutes with no update, Joget will pause it and allow the user to resume at a later time.
Enable Auto Archive
There are 2 ways to enable Auto archive or Archive Process on completion
1. Click on the button as shown in Figure 2 to enable Auto Archive. Alternatively, one may refer to Figure 3 and select Archive Process On Completion under Process Completion Data Handling tab.
...
The "Enable" button in "Monitor > Completed Processes" screen migrates (move) all existing completed process records to the history tables. We would recommend you perform the "Enable" after office hours as this will cause your Joget database to be very busy depending on how many completed process records you have in your system.
...
Navigate to Administrator Bar > Settings > General Settings > Process Completion Data Handling > Archive Process on Completion
When you set the General Settings "Archive Process On Completion" property, it will only archive all future new completed process records (applies to 8.0.6 and older builds only). The old or existing completed process records will remain unchanged. Process archiving on completed processes "moves" the process records to the following DB tables: wf_history_activity, wf_history_process, wf_process_link_history.
Enabling the 'Archive Process On Completion' option will initiate the data migration process to transfer completed process data to the historical tables immediately after saving. It is advisable to schedule this operation during non-peak hours for optimal performance.
...