topic Re: Activiti SQL query performance in Alfresco Forum

Activiti SQL query performance

yurifun — Wed, 05 Sep 2018 14:31:21 GMT

During tuning long time queries, we observed this queryselect distinct RES.*, DEF.KEY_ as PROC_DEF_KEY_, DEF.NAME_ as PROC_DEF_NAME_, DEF.VERSION_ as PROC_DEF_VERSION_, DEF.DEPLOYMENT_ID_ as DEPLOYMENT_ID_, VAR.ID_ as VAR_ID_, VAR.NAME_ as VAR_NAME_, VAR.VAR_TYPE_ as VAR_TYPE_, VAR.REV_ as VAR_RE

Re: Activiti SQL query performance

bassam_al-saror — Tue, 11 Sep 2018 15:28:56 GMT

There was a reason why the distinct keyword was added. Maybe not needed for all databases but in some it used to return duplicate records. You can use a native query or execute custom SQL to get a better performant query Activiti User Guide