nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Indexes on ACT_RU_VARIABLE will improve performance

mamue

Hi,

during jMeter tests with many open processes I found two indexes
which will improve performance significantly if there are many rows (1m+) in table ACT_RU_VARIABLE:

CREATE INDEX ACT_RU_VARIABLE_IDX1 ON ACT_RU_VARIABLE (BYTEARRAY_ID_);
CREATE INDEX ACT_RU_VARIABLE_IDX2 ON ACT_RU_VARIABLE (EXECUTION_ID_);‍‍

The first index improves performance when deleting rows from table ACT_GE_BYTEARRAY:
Before a row can be deleted the database has to check the foreign key constraint on column ACT_RU_VARIABLE.BYTEARRAY_ID_.
Without index this results in a time-consuming full table scan of column ACT_RU_VARIABLE.BYTEARRAY_ID_ for the ID_ of the row to be deleted.

What about adding these two indexes to Activiti?

Kind regards,
Markus Mueller

Find more posts tagged with

Comments

jbarrez

What database did you test this on?

mamue

We did most of our tests with PostgreSQL 9.2.
But the need to check if a record is referenced by any foreign keys seems to be RDBMS independent.
HTH

Sorry for my response being so late.

Kind regards,
Markus Müller