Elsa Startup Very Slow

[hendxxx]

Iam stuck in ELSA Startup

After investigation if not include Data, the query run normal

There is any way to exclude Data for Initial startup ???

[mohdali]

Do you have many suspended instances that are trying to resume during startup? That could be a reason.

[hendxxx]

no but, i have big json in Data field. Because i have to include base64 in there for infomation to bypass with ELSA

[hendxxx]

in total i have 416014066 byte ~ 400MB

[hendxxx]

I think, its not necessary to include Data while in the datatable, it important while get data, i'am right? since exclude Data at the service will run normal.

[jdevillard]

I don't have check the necessary of data at startup, but I've propose some improvements #3286 for the retention module that consist in not retrieving data.

Some of the new methods made available could be then use at startup.

[hendxxx]

Agree @jdevillard, I have my own database to store the workflow, the same way implemented to improve performance. Exclude DataAproval ([w].[Data] in context of ELSA) from querying to datatable, and its work and fast!

This is important because ELSA support long processing workflow, imagine we have running / suspend 200 approval with attachment each 5 Mb that store in json Data, its same with download 1Gb while startup, it's huge!

[hendxxx]

Any updates ??

[sfmskywalker]

A fix for the retention module is in the works, I believe there are some final issues that may or may not have been resolved by one or more open PRs. I.e. we're close to a fix it seems.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.