AnsweredAssumed Answered

Activiti performance testing results, XA trans question

Question asked by bwestrich on Feb 8, 2012
Latest reply on Feb 17, 2012 by ronald.van.kuijk
Hello Activiti users,

We've been trying out Activiti for the past few months and think it works great in general.

We've just finished our performance testing of it as well (with an Oracle database), and it performed reasonably well when using Oracle's non-XA driver. For example, in one of our tests we were able to perform around 500 transitions a second). 

Before testing, we followed some of the suggestions in this excellent forum post and its replies that was started by romanoff:
http://forums.activiti.org/en/viewtopic.php?f=6&t=1523

For example, we bumped up the id block size as follows:
<property name="idBlockSize" value="10000" />

And we also added a few indexes to the database……..
create index IDX_ACT_HI_ACTINST on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);
create index IDX_ACT_HI_PROCINST on ACT_HI_PROCINST(SUPER_PROCESS_INSTANCE_ID_);

I don't recall off the top of my head doing anything else related to performance tuning.

Based on these results, we're pretty sure Activiti will meet our needs related to performance.

But curiously, when we switch to the Oracle XA driver (not sure if we will use XA yet) (the driver name is oracle.jdbc.xa.client.OracleXADataSource) the performance decreases about ten fold. Our performance architect suspects "chattiness" between Activiti and the database. Has anyone else come across slow performance when using Activiti with XA?

Brian

P.S. Tests were run against an Oracle server with a single RAC node, with Java code executing inside a WebSphere 7 application server running on Solaris.

Outcomes