topic Indexes on ACT_RU_VARIABLE will improve performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/indexes-on-act-ru-variable-will-improve-performance/m-p/131928#M92702 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>during jMeter tests with many open processes I found two indexes </SPAN><BR /><SPAN>which will improve performance significantly if there are many rows (1m+) in table ACT_RU_VARIABLE:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>CREATE INDEX ACT_RU_VARIABLE_IDX1 ON ACT_RU_VARIABLE (BYTEARRAY_ID_);<BR />CREATE INDEX ACT_RU_VARIABLE_IDX2 ON ACT_RU_VARIABLE (EXECUTION_ID_);<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>The first index improves performance when deleting rows from table ACT_GE_BYTEARRAY:</SPAN><BR /><SPAN>Before a row can be deleted the database has to check the foreign key constraint on column ACT_RU_VARIABLE.BYTEARRAY_ID_.</SPAN><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>What about adding these two indexes to Activiti?</SPAN><BR /><BR /><SPAN>Kind regards,</SPAN><BR /><SPAN>Markus Mueller</SPAN><BR /><BR /></BODY></HTML> Tue, 14 May 2013 13:38:38 GMT mamue 2013-05-14T13:38:38Z Indexes on ACT_RU_VARIABLE will improve performance https://connect.hyland.com/t5/alfresco-archive/indexes-on-act-ru-variable-will-improve-performance/m-p/131928#M92702 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_ Tue, 14 May 2013 13:38:38 GMT https://connect.hyland.com/t5/alfresco-archive/indexes-on-act-ru-variable-will-improve-performance/m-p/131928#M92702 mamue 2013-05-14T13:38:38Z Re: Indexes on ACT_RU_VARIABLE will improve performance https://connect.hyland.com/t5/alfresco-archive/indexes-on-act-ru-variable-will-improve-performance/m-p/131929#M92703 <HTML><HEAD></HEAD><BODY><SPAN>What database did you test this on?</SPAN></BODY></HTML> Wed, 15 May 2013 13:40:12 GMT https://connect.hyland.com/t5/alfresco-archive/indexes-on-act-ru-variable-will-improve-performance/m-p/131929#M92703 jbarrez 2013-05-15T13:40:12Z Re: Indexes on ACT_RU_VARIABLE will improve performance https://connect.hyland.com/t5/alfresco-archive/indexes-on-act-ru-variable-will-improve-performance/m-p/131930#M92704 <HTML><HEAD></HEAD><BODY><SPAN>We did most of our tests with PostgreSQL 9.2.</SPAN><BR /><SPAN>But the need to check if a record is referenced by any foreign keys seems to be RDBMS independent.</SPAN><BR /><SPAN>HTH</SPAN><BR /><BR /><SPAN>Sorry for my response being so late.</SPAN><BR /><BR /><SPAN>Kind regards,</SPAN><BR /><SPAN>Markus Müller</SPAN></BODY></HTML> Tue, 03 Sep 2013 19:49:51 GMT https://connect.hyland.com/t5/alfresco-archive/indexes-on-act-ru-variable-will-improve-performance/m-p/131930#M92704 mamue 2013-09-03T19:49:51Z