topic How to control the poling interval on the ACT_RU_JOB table in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-control-the-poling-interval-on-the-act-ru-job-table/m-p/209480#M162610 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>I have a work flow with an expiration timer set on it. I see that the activiti polls on the ACT_RU_JOB. I see that the below two queries are being executed every time it polls.</SPAN><BR /><BR /><SPAN>select *</SPAN><BR /><SPAN>from ACT_RU_JOB</SPAN><BR /><SPAN>where (RETRIES_ &gt; 0) and (DUEDATE_ is null or DUEDATE_ &lt; :1) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; :2) and (RETRIES_ &gt; 0)</SPAN><BR /><SPAN>SQL Details: 3mwmj7bu8yw9w</SPAN><BR /><BR /><SPAN>select *</SPAN><BR /><SPAN>from ACT_RU_JOB</SPAN><BR /><SPAN>where (TYPE_ = 'timer') and (DUEDATE_ is not null) and (DUEDATE_ &lt; :1) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; :2) and (RETRIES_ &gt; 0) order by DUEDATE_</SPAN><BR /><BR /><SPAN>However I have large number of records in those tables and because activiti is polling I see that the above two queries are executing thousand of times in a soan of 15 mins. This is causing about 80% of my CPU time. Is there a way to manage the time interval at which activiti will poll for these tabels? what do you suggest so that these queries are not executed that frequently ?</SPAN><BR /><BR /><SPAN>Your advise is highly appreciated .</SPAN><BR /><SPAN>Thanks in advance !!!</SPAN><BR /><SPAN>Regards</SPAN><BR /><SPAN>Rajesh</SPAN></BODY></HTML> Wed, 25 Feb 2015 15:55:46 GMT rajeshiv 2015-02-25T15:55:46Z How to control the poling interval on the ACT_RU_JOB table https://connect.hyland.com/t5/alfresco-archive/how-to-control-the-poling-interval-on-the-act-ru-job-table/m-p/209480#M162610 Hi,I have a work flow with an expiration timer set on it. I see that the activiti polls on the ACT_RU_JOB. I see that the below two queries are being executed every time it polls.select *from ACT_RU_JOBwhere (RETRIES_ &gt; 0) and (DUEDATE_ is null or DUEDATE_ &lt; :1) and (LOCK_OWNER_ is null or LOC Wed, 25 Feb 2015 15:55:46 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-control-the-poling-interval-on-the-act-ru-job-table/m-p/209480#M162610 rajeshiv 2015-02-25T15:55:46Z Re: How to control the poling interval on the ACT_RU_JOB table https://connect.hyland.com/t5/alfresco-archive/how-to-control-the-poling-interval-on-the-act-ru-job-table/m-p/209481#M162611 <HTML><HEAD></HEAD><BODY><SPAN>See my answer in your other, exactly the same, post.</SPAN></BODY></HTML> Sat, 28 Feb 2015 09:34:28 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-control-the-poling-interval-on-the-act-ru-job-table/m-p/209481#M162611 jbarrez 2015-02-28T09:34:28Z