Thank you for your replies!
Huisheng
I took the standard configuration for 4.3. Where can I decrease transaction isolation?
Maciej:
I added your configuration part to jbpm.hibernate.cfg.xml. The results are better, but 70 ms vs. 25 ms is not really good.
jbpm.hibernate.cfg.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
-//Hibernate/Hibernate Configuration DTD 3.0//EN
http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd>
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpm</property>
<property name="hibernate.connection.username">username</property>
<property name="hibernate.connection.password">password</property>
<property name="hibernate.hbm2ddl.auto">create-drop</property>
<property name="hibernate.format_sql">true</property>
<property name="hibernate.use_sql_comments">true</property>
<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
<property name="hibernate.cache.use_second_level_cache">true</property>
<property name="hibernate.cache.use_query_cache">true</property>
<mapping resource="jbpm.repository.hbm.xml" />
<mapping resource="jbpm.execution.hbm.xml" />
<mapping resource="jbpm.history.hbm.xml" />
<mapping resource="jbpm.task.hbm.xml" />
<mapping resource="jbpm.identity.hbm.xml" />
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
<class-cache usage="nonstrict-read-write"/>
</session-factory>
</hibernate-configuration>
Regards,
Christian