I have done a POC with activiti. So far so good. Now trying to investigate and test adding state management in the workflow's
Here are my technical questions.
1) We will have 1000's of marketing campaigns which is your workflow processes.
2) Each workflow process can panel 2 or 3 million customers out of 30 million AIM users
3) So my question is how the datastore is managed …will activiti support multiple instances of dbs with some RANGE or HASH or KEY partitioning based on guid or userId.
4) The state management for each of the customer can process a lot data. Does all the data get stored in the ACT_RU_VARIABLE table ? is there a compression algorithm being using to store variables in TEXT_VARCHAR and TEXT2_VARCHAR. How can we avoid that storage and instead always get the data ?