Improves the efficiency of flow track tables of workflow engines.
------------------------------------------------------------
Keywords: workflow engine Workflow Management System ccflow flow track wf_track
What is a process track table?
It is the trajectory data table that ccflow is used to store each step of operation in the lifecycle of the entire process. It is stored in the wf_track table.
Why?
1. frequent access.
2. The inserted data is large and frequent.
3. It brings a lot of problems to the process execution efficiency, especially after the year 23 s of the process operation.
How can we make changes? What is the change plan?
1. A wf_tracktemp table is created to temporarily store track data.
2. Periodically copy data from the wf_tracktemp data table to wf_track during scheduling and delete data that has been copied.
3. Scheduling is executed every day and night, completed by D: \ ccflow \ visualworkflowservices \ bin \ release \ ccflowservices.exe.
If ccflow is distributed in two tables, how does one view the historical track of the process? Does it affect historical data?
The Union method is used to complete the process without affecting the historical data.
Others:
1. The flow track is distributed in two data tables, and ccflow is queried by union.
2. This change will not affect historical data.
3. users who have no efficiency problems do not need to update the service because the service volume is small and the service time is not long.
Update content:
All.
Http://ccflow.org