topic Performance on JPA with BPMN. (How updates are executed on a JPA Entity during a flow) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/performance-on-jpa-with-bpmn-how-updates-are-executed-on-a-jpa/m-p/205695#M158825 <HTML><HEAD></HEAD><BODY><SPAN>Performance on JPA with BPMN. (How updates are executed&nbsp; on a JPA Entity during a flow)</SPAN><BR /><BR /><SPAN>Hi everyone,</SPAN><BR /><BR /><SPAN>I don't fully understand how updates are generated when Activiti manages a JPA Entity. I have this feature working, but I would like to know if there is a performance improvement to apply on this point by changing some configuration. </SPAN><BR /><BR /><SPAN>The scenario is as follows: Let's say I have a flow called remodelHouse.bpmn and a 'House' Entity, which I pass to Activiti&nbsp; when I execute the method startProcessInstanceByKey(). In this flow, I have a task which changes the House attribute 'numberOfRooms' and another different task which changes the House attribute 'wallsColor'.</SPAN><BR /><BR /><SPAN>Activiti manages the flow as a transaction, but when I inspect the updates issued by Activiti, I see 2 different updates, as follows:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />update House set numberOfRooms = 'newNumberOfRoom' where…<BR />update House set wallsColor = 'newColor' where…<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>And what I would like to be issued is:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />update House set numberOfRooms = 'newNumberOfRoom', wallsColor = 'newColor'&nbsp; where…<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>is possible to tell Activity to apply all changes on an Entity all together at the end of the flow, in order to avoid the extra statements?</SPAN><BR /><BR /><SPAN>Thanks in advance!</SPAN><BR /></BODY></HTML> Thu, 04 Dec 2014 20:25:18 GMT leac87 2014-12-04T20:25:18Z Performance on JPA with BPMN. (How updates are executed on a JPA Entity during a flow) https://connect.hyland.com/t5/alfresco-archive/performance-on-jpa-with-bpmn-how-updates-are-executed-on-a-jpa/m-p/205695#M158825 Performance on JPA with BPMN. (How updates are executed&nbsp; on a JPA Entity during a flow)Hi everyone,I don't fully understand how updates are generated when Activiti manages a JPA Entity. I have this feature working, but I would like to know if there is a performance improvement to apply on this point Thu, 04 Dec 2014 20:25:18 GMT https://connect.hyland.com/t5/alfresco-archive/performance-on-jpa-with-bpmn-how-updates-are-executed-on-a-jpa/m-p/205695#M158825 leac87 2014-12-04T20:25:18Z Re: Performance on JPA with BPMN. (How updates are executed on a JPA Entity during a flow) https://connect.hyland.com/t5/alfresco-archive/performance-on-jpa-with-bpmn-how-updates-are-executed-on-a-jpa/m-p/205696#M158826 <HTML><HEAD></HEAD><BODY><SPAN>Currently, we don't support combining updates into one update statement, so you'll see multiple updates to the same entity. But I agree it would be a nice feature to have.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 05 Dec 2014 12:31:18 GMT https://connect.hyland.com/t5/alfresco-archive/performance-on-jpa-with-bpmn-how-updates-are-executed-on-a-jpa/m-p/205696#M158826 trademak 2014-12-05T12:31:18Z Re: Performance on JPA with BPMN. (How updates are executed on a JPA Entity during a flow) https://connect.hyland.com/t5/alfresco-archive/performance-on-jpa-with-bpmn-how-updates-are-executed-on-a-jpa/m-p/205697#M158827 <HTML><HEAD></HEAD><BODY><SPAN>Ah ok I see, thank you for your response!</SPAN><BR /></BODY></HTML> Fri, 05 Dec 2014 14:11:14 GMT https://connect.hyland.com/t5/alfresco-archive/performance-on-jpa-with-bpmn-how-updates-are-executed-on-a-jpa/m-p/205697#M158827 leac87 2014-12-05T14:11:14Z