topic Re: Serious multithreading problem with embedded Activiti in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/serious-multithreading-problem-with-embedded-activiti/m-p/58762#M36017 <HTML><HEAD></HEAD><BODY><SPAN>Gergely,</SPAN><BR /><BR /><SPAN>Activiti comes with a (limited) set of indeces, mainly of FK's. If you do queries on e.g. process variables in your code, that can result in full table scans and locks. (See another post in the forum about jmeter tests). So analyzing that is what you should do first. For the other poster it prevented lots of issues.</SPAN><BR /><BR /><SPAN>The reason Activiti cannot (will not) provide all indeces, is that to many indeces slows the db down considerably. So They should be tuned to the specific usage.</SPAN><BR /><BR /><SPAN>hth (to some extend)</SPAN></BODY></HTML> Thu, 21 Jul 2011 10:55:19 GMT ronald_van_kuij 2011-07-21T10:55:19Z Serious multithreading problem with embedded Activiti https://connect.hyland.com/t5/alfresco-archive/serious-multithreading-problem-with-embedded-activiti/m-p/58761#M36016 Hi guys!We are using Activiti in our project. It was a very good experience so far for the whole team, both the product andthe documentation was great.Our application has a Spring 3 / Hibernate backend and we use the Activiti engine embedded into our Spring configuration.The Spring integration looke Thu, 21 Jul 2011 09:30:13 GMT https://connect.hyland.com/t5/alfresco-archive/serious-multithreading-problem-with-embedded-activiti/m-p/58761#M36016 gergelydombi 2011-07-21T09:30:13Z Re: Serious multithreading problem with embedded Activiti https://connect.hyland.com/t5/alfresco-archive/serious-multithreading-problem-with-embedded-activiti/m-p/58762#M36017 <HTML><HEAD></HEAD><BODY><SPAN>Gergely,</SPAN><BR /><BR /><SPAN>Activiti comes with a (limited) set of indeces, mainly of FK's. If you do queries on e.g. process variables in your code, that can result in full table scans and locks. (See another post in the forum about jmeter tests). So analyzing that is what you should do first. For the other poster it prevented lots of issues.</SPAN><BR /><BR /><SPAN>The reason Activiti cannot (will not) provide all indeces, is that to many indeces slows the db down considerably. So They should be tuned to the specific usage.</SPAN><BR /><BR /><SPAN>hth (to some extend)</SPAN></BODY></HTML> Thu, 21 Jul 2011 10:55:19 GMT https://connect.hyland.com/t5/alfresco-archive/serious-multithreading-problem-with-embedded-activiti/m-p/58762#M36017 ronald_van_kuij 2011-07-21T10:55:19Z