topic Re: How can I increase the batch size default of 1000 in merge process? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183970#M137100 <HTML><HEAD></HEAD><BODY><SPAN>You're using many words which are unknown to me, I still don't get what 'merge' is in this context, nor if the batch size is something you expect from Activiti or from your database? </SPAN><BR /><BR /><SPAN>Looking at the link, I am assuming you need to set a batch size for your database? If this is not set in the jdbc url, then i dont believe you can set it directly in Activiti.</SPAN></BODY></HTML> Tue, 26 May 2015 08:08:52 GMT jbarrez 2015-05-26T08:08:52Z How can I increase the batch size default of 1000 in merge process? https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183967#M137097 I am new to Activiti framework and the project was outsourced before I join the team. The project is based on Activiti framework, the database is sqlserver and tomcat as an application server. Whenever I had a merge process(a new instance process), in the console log it displays that for creating an Fri, 15 May 2015 18:23:37 GMT https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183967#M137097 somy 2015-05-15T18:23:37Z Re: How can I increase the batch size default of 1000 in merge process? https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183968#M137098 <HTML><HEAD></HEAD><BODY><SPAN>What do you mean with 'merge' here? And what batch size property are we talking about here?</SPAN></BODY></HTML> Mon, 18 May 2015 15:56:49 GMT https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183968#M137098 jbarrez 2015-05-18T15:56:49Z Re: How can I increase the batch size default of 1000 in merge process? https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183969#M137099 <HTML><HEAD></HEAD><BODY><SPAN>One of the customized features in the Process/"Deployed process definitions" menu is Worklist Merge, by starting this process one instance would be created and this will create one new job. In the background one process is created and will be completed after merging. Here this merge doesn't happen in seconds, for example if we had count size of 20k rows for merge, it'll be divided to some batches with default size of 1000. If it could happen all together it would be really faster. I couldn't find the batch size configuration, I just found in google such as :</SPAN><BR /><A href="https://technet.microsoft.com/en-us/library/dd425070(v=sql.100).aspx" rel="nofollow noopener noreferrer">https://technet.microsoft.com/en-us/library/dd425070(v=sql.100).aspx</A><BR /><SPAN> If BATCH_SIZE is not specified, BCP will use 1000 as the default value.</SPAN><BR /><BR /><SPAN>But where can I change this batch size?</SPAN></BODY></HTML> Mon, 18 May 2015 17:14:47 GMT https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183969#M137099 somy 2015-05-18T17:14:47Z Re: How can I increase the batch size default of 1000 in merge process? https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183970#M137100 <HTML><HEAD></HEAD><BODY><SPAN>You're using many words which are unknown to me, I still don't get what 'merge' is in this context, nor if the batch size is something you expect from Activiti or from your database? </SPAN><BR /><BR /><SPAN>Looking at the link, I am assuming you need to set a batch size for your database? If this is not set in the jdbc url, then i dont believe you can set it directly in Activiti.</SPAN></BODY></HTML> Tue, 26 May 2015 08:08:52 GMT https://connect.hyland.com/t5/alfresco-archive/how-can-i-increase-the-batch-size-default-of-1000-in-merge/m-p/183970#M137100 jbarrez 2015-05-26T08:08:52Z