topic Solution: improve performace in Alfresco in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236653#M189783 <HTML><HEAD></HEAD><BODY><SPAN>when you use Alfresco common problem is the </SPAN><STRONG>performance</STRONG><SPAN>! Here I did not mention the issue because the hardware configuration server can normally meet for 100-1000 users that are written pretty much on the forum so I just put out a solution but it is very useful to the development and location management system my Alfresco!</SPAN><BR /><BR /><SPAN>Common problem is when you completed the task pane open&nbsp; :mrgreen:&nbsp; then all tasks will be completed with status paging load on your screen at this time is completed, the panel TASKs any action on your next (e.g: you click on page 2 or click menu on the left navigator) then load operation completed all tasks are done again this makes the performance is limited!</SPAN><BR /><BR /><SPAN>The solution here is to put more load conditions for the tasks can be completed by the date created (can only load the tasks completed in two months), provided that you can put in xml file (which can be done by the code read to get info from param xml file) for editing upon request from the end users :mrgreen:</SPAN><BR /><BR /><SPAN>View file JBPMEngine.java (press Ctr+R in Eclipse):</SPAN><BR /><SPAN>this is string for QUERY get tasks Completed in 2 month:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>private final static String COMPLETED_TASKS_QUERY =&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;"select ti from org.jbpm.taskmgmt.exe.TaskInstance as ti " +<BR />&nbsp;&nbsp;&nbsp;"where ti.actorId = :actorId " +<BR />&nbsp;&nbsp;&nbsp;"and ti.isOpen = false " +<BR />&nbsp;&nbsp;&nbsp;"and to_char(sysdate,'yyddd')-to_char(ti.end,'yyddd')&lt;=60 "; // vinaxwater added<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>this is string for QUERY get 60 rows tasks completed to the query:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>private final static String COMPLETED_TASKS_QUERY =&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;"select ti from org.jbpm.taskmgmt.exe.TaskInstance as ti " +<BR />&nbsp;&nbsp;&nbsp;"where ti.actorId = :actorId " +<BR />&nbsp;&nbsp;&nbsp;"and ti.isOpen = false " +<BR />&nbsp;&nbsp;&nbsp;"and rownum &lt;= :rw "; // vinaxwater added<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>find method findCompletedTaskInstances:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>After row: query.setString("actorId", actorId);<BR />Add:&nbsp;&nbsp;&nbsp; query.setString("rw", "60"); // vinaxwater added<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>The conditions you can start with the fields in tables JBPM_TASKINSTANCE!</SPAN><BR /><BR /><SPAN>You can change the hard conditions by reading from the xml file for conditions when requested changes are not necessarily re-build source that just change the xml file for effect :mrgreen: and you can also apply in process or task to load the content in Alfresco :mrgreen:</SPAN><BR /><SPAN>This is useful for improving performance using Alfresco very much!</SPAN><BR /><SPAN>Note: I am using Alfresco 2.9B build version. No way affect the search content in Alfresco system because otherwise use search module :mrgreen:</SPAN><BR /><BR /><SPAN>Hope this helps you!</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>vinaxwater</SPAN></BODY></HTML> Mon, 05 Apr 2010 04:07:10 GMT vinaxwater 2010-04-05T04:07:10Z Solution: improve performace in Alfresco https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236653#M189783 when you use Alfresco common problem is the performance! Here I did not mention the issue because the hardware configuration server can normally meet for 100-1000 users that are written pretty much on the forum so I just put out a solution but it is very useful to the development and location manage Mon, 05 Apr 2010 04:07:10 GMT https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236653#M189783 vinaxwater 2010-04-05T04:07:10Z Re: Solution: improve performace in Alfresco https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236654#M189784 <HTML><HEAD></HEAD><BODY><SPAN>Did it make the performance better? How many times?</SPAN></BODY></HTML> Wed, 16 Jun 2010 17:53:51 GMT https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236654#M189784 nhienmai 2010-06-16T17:53:51Z Re: Solution: improve performace in Alfresco https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236655#M189785 <HTML><HEAD></HEAD><BODY><SPAN>And if you have what you think is useful code then please contribute it so it can go into the base product.</SPAN></BODY></HTML> Wed, 16 Jun 2010 18:00:57 GMT https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236655#M189785 mrogers 2010-06-16T18:00:57Z Re: Solution: improve performace in Alfresco https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236656#M189786 <HTML><HEAD></HEAD><BODY><SPAN>Hi friends,</SPAN><BR /><SPAN>I think in panel Task Completed load all is useful for performance! it ought to load according to parameter input form user (e.x it can date) i think useful for performance of system.</SPAN><BR /><SPAN>Before it's always load all Task Completed of user current login in system ( can 500 record ) but present it only load 50 record&nbsp; ( Task Complete in one month ) in session login&nbsp; :roll:</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>vinaxwater</SPAN></BODY></HTML> Thu, 17 Jun 2010 03:17:03 GMT https://connect.hyland.com/t5/alfresco-archive/solution-improve-performace-in-alfresco/m-p/236656#M189786 vinaxwater 2010-06-17T03:17:03Z