topic trouble with query in our database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181255#M134385 <HTML><HEAD></HEAD><BODY><SPAN>out DB is Oracle 11g</SPAN><BR /><BR /><SPAN>we see 1 trouble query</SPAN><BR /><BR /><SPAN>SELECT *</SPAN><BR /><SPAN>&nbsp; FROM (SELECT a.*, ROWNUM rnum</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM (SELECT RES.*</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM ACT_RU_JOB RES</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp;&nbsp;&nbsp;&nbsp; (RETRIES_ &gt; 0)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (DUEDATE_ IS NULL OR DUEDATE_ &lt; :1)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (LOCK_OWNER_ IS NULL OR LOCK_EXP_TIME_ &lt; :2)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (EXCLUSIVE_ = 1)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (PROCESS_INSTANCE_ID_ = :3)) a</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ROWNUM &lt; :4)</SPAN><BR /><SPAN> WHERE rnum &gt;= :5</SPAN><BR /><BR /><SPAN>it runs very slow.</SPAN><BR /><BR /><SPAN>how it fix?</SPAN></BODY></HTML> Fri, 08 May 2015 11:15:34 GMT neosss 2015-05-08T11:15:34Z trouble with query in our database https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181255#M134385 out DB is Oracle 11gwe see 1 trouble querySELECT *&nbsp; FROM (SELECT a.*, ROWNUM rnum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM (SELECT RES.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM ACT_RU_JOB RES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp;&nbsp;&nbsp;&nbsp; (RETRIES_ &gt; 0)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (DUEDATE_ IS NULL OR DUEDATE_ &lt; :1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (LOCK_OWNER_ IS NU Fri, 08 May 2015 11:15:34 GMT https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181255#M134385 neosss 2015-05-08T11:15:34Z Re: trouble with query in our database https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181256#M134386 <HTML><HEAD></HEAD><BODY><SPAN>Which version of Activiti are you using? With Activiti 5.17 we introduced a new async job executor which improves the job queries a lot.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 13 May 2015 12:50:23 GMT https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181256#M134386 trademak 2015-05-13T12:50:23Z Re: trouble with query in our database https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181257#M134387 <HTML><HEAD></HEAD><BODY><SPAN>we use 5.14 version of Activity.</SPAN><BR /><BR /><SPAN>ok. we'll try 5.17</SPAN><BR /><BR /><SPAN>thanks</SPAN></BODY></HTML> Thu, 14 May 2015 07:42:42 GMT https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181257#M134387 neosss 2015-05-14T07:42:42Z