topic Re: Indexes on ACT_RU_VARIABLE will improve performance in Alfresco Archive

Indexes on ACT_RU_VARIABLE will improve performance

mamue — Tue, 14 May 2013 13:38:38 GMT

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_

Re: Indexes on ACT_RU_VARIABLE will improve performance

jbarrez — Wed, 15 May 2013 13:40:12 GMT

What database did you test this on?

Re: Indexes on ACT_RU_VARIABLE will improve performance

mamue — Tue, 03 Sep 2013 19:49:51 GMT

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