topic Re: task complete performance issue in Alfresco Archive

task complete performance issue

huck34 — Fri, 28 Aug 2015 13:03:26 GMT

I am working on activiti 5.13When I complete task. It takes 2 seconds. It's too long. Any Suggestion is appreciated.My database is sqlserver 2012The following is the code takes me 2 seconds. nothing else.taskService.complete(taskId, vars);It generates bunch of code insert,update,select activiti data

Re: task complete performance issue

vasile_dirla — Fri, 28 Aug 2015 13:21:00 GMT

Hi,
please don't double post in the future.
http://forums.activiti.org/content/task-complete-performance-issue

did you test it with other database server?
Will be nice if you could create a unit test to show this issue.

Re: task complete performance issue

huck34 — Fri, 28 Aug 2015 14:29:26 GMT

No I didn't test it with other database server. I ran unit test it also takes 2 seconds. I search the google. I got benchmark activiti should take less than 40 millseconds. So I wonder whether I got something wrong on configuation.As for history configuation I change from full to audit.It save 20% of time.After the current node, next task is multi instance task. I wonder whether activiti has any other configuation do great help to performance. Is there any configuation sqlserver2012 should set to improve activiti performance. It looks task complete method
takes too long. I turn on the logs it generate sql against activiti database. Any suggestion? Thanks in advance.

Re: task complete performance issue

vasile_dirla — Fri, 28 Aug 2015 19:46:11 GMT

Hi,
did you have any special reason to use 5.13 ?
if not, we strongly recommend to upgrade to the latest version.

also, please create a unit test which will show this behaviour. (don't forget to include the process xml, config etc.., a nicely done unit test will help other to investigate the problem)

http://forums.activiti.org/content/sticky-how-write-unit-test

note: please rename the zip file to txt before uploading

Re: task complete performance issue

huck34 — Fri, 28 Aug 2015 22:41:57 GMT

I will provide unit test when I get into office on Monday. Thanks a lot. By the way the reason we working on 5.13 is we start activiti workflow development long ago. 5.13 has run into production environment for several years. But at that time we use little activiti workflow. Right now company requirement boost.Performance issue becomes a big issue.

Re: task complete performance issue

huck34 — Mon, 31 Aug 2015 03:13:22 GMT

Hello, the unit test is in the attachment, the time it takes is too long, thanks in advance.

Re: task complete performance issue

huck34 — Mon, 31 Aug 2015 04:41:43 GMT

unit test is provided.

Re: task complete performance issue

huck34 — Mon, 31 Aug 2015 08:45:14 GMT

This attachment contains the sqls executed in activiti, the number of sqls is too many and it totally takes about 10 seconds, just for your information.