topic Re: SQL Query performance is slow when joining varaible table in Alfresco Archive

SQL Query performance is slow when joining varaible table

ganeshr — Mon, 23 Dec 2013 17:09:11 GMT

Hi, Here is the query I'm using and when executing it is almost taking 4-5 seconds. but when I remove joining variable table, then query is returning in millisecondsselect count(distinct task.ID_) from ACT_RU_TASK task inner join ACT_RU_IDENTITYLINK identity on identity.TASK_ID_ = task.ID_

Re: SQL Query performance is slow when joining varaible table

jbarrez — Tue, 24 Dec 2013 09:38:31 GMT

The first thing to investigate is what an additional index would do.
Activiti has some out of the box indices, but the idea is generally that you tweak the DB schema to your need when it comes to indices.

Re: SQL Query performance is slow when joining varaible table

ganeshr — Thu, 26 Dec 2013 15:22:03 GMT

Thank you.