topic Re: Performance issue in query ot get row of ACT_HI_VARINST in Alfresco Archive

Performance issue in query ot get row of ACT_HI_VARINST

hsimon — Thu, 18 Sep 2014 09:06:48 GMT

Hi,I just registered to this forum since I have to support the activity engine by a customer. We found that the cost for following query is very high:select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_VARINST RES WHERE RES.TASK_ID_ = ? order by RES.ID_ asc ) a where ROWNUM <

Re: Performance issue in query ot get row of ACT_HI_VARINST

trademak — Thu, 18 Sep 2014 13:39:05 GMT

Hi Harald,

Could you create a JIRA issue so we can track this issue? I'll add the index to the create scripts already.

Thanks,

Re: Performance issue in query ot get row of ACT_HI_VARINST

hsimon — Thu, 18 Sep 2014 14:52:32 GMT

Hi Tijs,

a new issue has been created.

thanks!

Regards

Harald