topic using custom table instead of ACT_RU_VARIABLE in Alfresco Archive

using custom table instead of ACT_RU_VARIABLE

vamsidharyeddu — Tue, 29 Mar 2016 12:28:27 GMT

Hello, We use activiti for our business process. We were using ACT_RU_VARIABLE(in the form of key,value pairs) to store information related to a process instance. And a lot of information is currently being stored in that way which made the dashboard(activiti explorer) very slow. So we decid

Re: using custom table instead of ACT_RU_VARIABLE

hari — Wed, 30 Mar 2016 05:44:18 GMT

Hi Vamsidhar,

I don't think having lot of information in a table will slow down the application since you wont be fetching all the information in the table onto the dashboard. Also it is not recommended to have your own table and tweak the activiti source code since the community or the activiti wont support the implementations.
To add to it, another issue would be when you have to upgrade to newer version of Activiti you will have to tweak the source code again.
We have been using activiti with postgres and have close to 30k+ records in that table but still we never faced any issues in terms of application getting slow.
So all I would say is that the approach you have taken is not recommened or suggested. Try to find the actual reason which is causing an issue for you and evaluate other options for solving it.

Re: using custom table instead of ACT_RU_VARIABLE

jyotigupta — Thu, 31 Mar 2016 06:34:23 GMT

@ asriharikiran

We have around 300K+ records in ACT_RU_VARIABLE due to which we are facing this issue.
Is there any other way to do this?

Re: using custom table instead of ACT_RU_VARIABLE

hari — Mon, 04 Apr 2016 07:17:41 GMT

Hi Jyoti,
3 Lakh records should not be a big deal for a database. I would recommend to index your tables.Also go through the below link and see if it helps.
http://www.catswhocode.com/blog/10-sql-tips-to-speed-up-your-database