nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

Find more posts tagged with

Comments

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

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

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

unit test.zip_.txt.zip

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.

Activitisql.txt.zip