task complete performance issue

[huck34]

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

[vasile_dirla]

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.

[huck34]

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.

[vasile_dirla]

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

[huck34]

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

[huck34]

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.

[huck34]

unit test is provided.

[huck34]

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.